Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple IF functions
I need one function to always be true and then two IF functions, but can't
seem to get them all to work together. =C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO") Thank you. |
#2
|
|||
|
|||
In addition, I've tried this,
=IF(C11,C1*.005,IF(B1=A1,C1*.01,IF(B1=D1,C1*.01 2,"NO"))) but keep getting the result from the first IF function no matter what I enter for B1. Thank you. "sonicj" wrote: I need one function to always be true and then two IF functions, but can't seem to get them all to work together. =C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO") Thank you. |
#3
|
|||
|
|||
Hi!
but keep getting the result from the first IF function no matter what I enter for B1. =IF(C11 If that condition is true the formula stops at this point: =IF(C11,C1*.005) It doesn't matter what you enter in B1 because the formula never gets that far if C11. There's nothing wrong with the formula' syntax. May be that the logic is just not correct for the result you're after. Biff -----Original Message----- In addition, I've tried this, =IF(C11,C1*.005,IF(B1=A1,C1*.01,IF (B1=D1,C1*.012,"NO"))) but keep getting the result from the first IF function no matter what I enter for B1. Thank you. "sonicj" wrote: I need one function to always be true and then two IF functions, but can't seem to get them all to work together. =C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO") Thank you. . |
#4
|
|||
|
|||
Hi
Try this: =IF(B1=A1,C1*0.11,IF(B1=D1,C1*0.012,IF(C11,C1*0 .005,"NO"))) HTH Michael "sonicj" wrote: I need one function to always be true and then two IF functions, but can't seem to get them all to work together. =C1*.005,IF(B1=A1,C1*.01,"NO"),IF(B1=D1,C1*.012, "NO") Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use multiple nested functions? | Excel Worksheet Functions | |||
Best technique to perform multiple calculations ? | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |