IF OR Statement

[DJPaton]

Hi Everyone, I hope tou are all well and greatings from Sydney Australia. I have a simple IF OR statement that I just cannot get to work, I am sure it is staring me in the face but alas.....

=IF(OR(G2=230070,G2=230071,BA2*70%),IF(OR(BC2=0,BA2=0,"0",BA2-BC2)

Excel keeps stating I am missing or require a parenthesis, tried a number of options for a while, any help would be hugely appreciated.

All the best

Derek

 

[Michael M]

Maybe this

=IF(OR(G2=230070,G2=230071),BA2*70%,IF(OR(BC2=0,BA2=0),"0",BA2-BC2))

 

[awoohaw]

you have at least two parens or expressions wrong. although i can't tell what you really want to do.
IF(OR(G2=230070,G2=230071,BA2*70%) the underline needs to be an equation if is is part of your OR statement.
and if that is true, the next if is what happens if your first OR is TRUE, and the 2nd IF is missing a Paren after the BA2=0.
my guess is you want this:

=IF(OR(G2=230070,G2=230071),BA2*70%,IF(OR(BC2=0,BA2=0),"0",BA2-BC2))

 

[DJPaton]

Maybe this

=IF(OR(G2=230070,G2=230071),BA2*70%,IF(OR(BC2=0,BA2=0),"0",BA2-BC2))

Perfect thank you, that totally makes sense and worked exactly as I need it to so thank you so very much again.

 

[DJPaton]

Maybe this

=IF(OR(G2=230070,G2=230071),BA2*70%,IF(OR(BC2=0,BA2=0),"0",BA2-BC2))

Thank you so much Michael, as mentioned in my post below the formula worked perfectly, you both cam up with the same formula which is brilliant, again thank you so very much.

 

[Michael M]

Glad we could help..