conditional formula

  • Thread starter Thread starter lena
  • Start date Start date
L

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?
 
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
 
THANK YOU !!!! Works perfectly!
--
lena


Max said:
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
Click to expand...
 
Back
Top