conditional formula
 

I have this formula:
=(B880%)*(B12*0.38%)/12
How do I add to the above a 2nd and 3rd condition such as:
(B885.01%)*(B12*.64%)/12
(B890.01%)*(B12*.94%)/12
And what is the term to describe this?
--
lena

conditional formula
 

You could try a nested IF, like this:
=IF(B890.01%,(B12*0.94%)/12,IF(B885.01%,(B12*0.64%)/12,IF(B880%,(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" wrote:
I have this formula:
=(B880%)*(B12*0.38%)/12
How do I add to the above a 2nd and 3rd condition such as:
(B885.01%)*(B12*.64%)/12
(B890.01%)*(B12*.94%)/12
And what is the term to describe this?

conditional formula
 

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


"Max" wrote:

You could try a nested IF, like this:
=IF(B890.01%,(B12*0.94%)/12,IF(B885.01%,(B12*0.64%)/12,IF(B880%,(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" wrote:
I have this formula:
=(B880%)*(B12*0.38%)/12
How do I add to the above a 2nd and 3rd condition such as:
(B885.01%)*(B12*.64%)/12
(B890.01%)*(B12*.94%)/12
And what is the term to describe this?

conditional formula
 

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
---
"lena" wrote:
THANK YOU !!!! Works perfectly!