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

Multiple options- answer in single cel 2
Compare and replace if equal 6
Shift down and then to the right 1
Fill down Formula Automatically 2
Data Validation and drop-down list using IF, AND and what else? 8
INDEX, MATCH, AND OFFSET... OH MY! 4
If Function with Text Formatting 5
Insert columns and values programmatically with IF statement 9

Top