Conditional function

S

Sonia

I need to make a conditional formula based ont he below info

If A=75 then the column B must show 5%
If A >90 & <=99 then column B must show 7%
If A = 100 then Column B must show 8%

Please help me make this formula
 
P

Pete_UK

There are some other conditions not covered by your requirements, i.e.
if A < 75, or A >75 and <=90, or A >100. What do you want to happen in
these cases?

Pete
 
B

bj

=if(A1=100,.08,if(A1>90,0.07,if(A1=75,0.05,"")))
assuming you want it blank when none of the conditins are met.
 
T

Teethless mama

=IF(A1=75,0.05,IF(A1<=90,0.06,IF(A1<=99,0.07,IF(A1=100,0.08,"else…."))))
 
B

bj

you are right I assumed that 100 was the max the value would be, with no
justification for the assumption.
=if(A1=100,.08,if(and(A1>90,A1<=99),0.07,if(A1=75,0.05,"")))
 
Top