IF function with AND, having problems.

S

sirjbean

I am trying to allow a cell to gather data from two cells and return a
numeric amount based on that data.
B1 =250
A2="sp"
C2 should take the input from the 2 cells above and if both are true
then enter a multiplier of .5. If A2 ="SB" and B1=250 then the
mutliplier should be.75. Additionally if B1=500 then the multipliers
would become .85 and 1.30 respectively.

How do I write the functions to make this occur?
 
B

Bob Phillips

=IF(A2="sp",IF(B1=250,0.5,IF(B1=500,0.85,"what
here?")),IF(A1="SB",IF(B1=250,0.75,IF(B1=500,1.3,"and what here?")),"or even
here?"))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching Data between 2 Tabs on Same Workbook - then calculating 2
Multiple options- answer in single cel 2
tabulate output data from different combination of input. 0
? Function to copy based on choice 5
Formula to sum up customers totals from other sheets 1
reverse pasting rows with alternate blank cells 0
Excel 2002: How to lookup the last number and text in a column ? 3
SUM columns based on 2 pieces of logic 2

Top