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.

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.

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.