Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple If Function Question
I have a working If function that says, IF(AB, A-C+D, E), and I want
to add an additional intruction to this that states that IF(B=0, E, 0) as opposed to it defaulting to the "A-C+D" calculation. How can I add this additional funtion to the current function. I think it has something to do with an "AND" or an "OR". Any help will be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple If Function Question
not sure what you need but try this
=IF(AND(A1B1,B1=0),E1,0) "NewUser22" wrote: I have a working If function that says, IF(AB, A-C+D, E), and I want to add an additional intruction to this that states that IF(B=0, E, 0) as opposed to it defaulting to the "A-C+D" calculation. How can I add this additional funtion to the current function. I think it has something to do with an "AND" or an "OR". Any help will be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple If Function Question
NewUser22,
try =IF(AND(A1B1,B10), A1-C1+D1,E1) -- Hope that helps. Vergel Adriano "NewUser22" wrote: I have a working If function that says, IF(AB, A-C+D, E), and I want to add an additional intruction to this that states that IF(B=0, E, 0) as opposed to it defaulting to the "A-C+D" calculation. How can I add this additional funtion to the current function. I think it has something to do with an "AND" or an "OR". Any help will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Sum function question | Excel Worksheet Functions | |||
Probably simple question on AVG function | Excel Discussion (Misc queries) | |||
Simple Function question? | Excel Worksheet Functions | |||
simple function question | Excel Programming | |||
Simple Function question | Excel Programming |