conditional formula

[lena]

I have this formula:
=(B8>80%)*(B12*0.38%)/12
How do I add to the above a 2nd and 3rd condition such as:
(B8>85.01%)*(B12*.64%)/12
(B8>90.01%)*(B12*.94%)/12
And what is the term to describe this?

 

[Max]

You could try a nested IF, like this:
=IF(B8>90.01%,(B12*0.94%)/12,IF(B8>85.01%,(B12*0.64%)/12,IF(B8>80%,(B12*0.38%)/12,0)))

The left to right sequence in the expression is important. And I've taken
the liberty to have it returned as zero if the value in B8 is <=80%.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[lena]

THANK YOU !!!! Works perfectly!
--
lena

You could try a nested IF, like this:
=IF(B8>90.01%,(B12*0.94%)/12,IF(B8>85.01%,(B12*0.64%)/12,IF(B8>80%,(B12*0.38%)/12,0)))

The left to right sequence in the expression is important. And I've taken
the liberty to have it returned as zero if the value in B8 is <=80%.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik

 

[Max]

Glad to hear. Pl mark all responses which help by clicking the YES buttons
below. Thanks
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik