| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
| Conditional Formula help | Excel Discussion (Misc queries) | |||
| Conditional Formula to indicate Formula in cell | New Users to Excel | |||
| Conditional Formula | Excel Discussion (Misc queries) | |||
Linear Mode
