IF OR functions, unless a certain condition is met

[Captain Hindsight]

Hi all,

What I want to achieve is this:

Display me a set value e.g. 10, every time that EITHER condition A or condition B are met, UNLESS a given cell = 0.

To give some context, this is relating to deliveries of a product. I am forecasting the costs incurred over a period of years where certain conditions have to be met and if there are no deliveries I don't want any values returned.

I have this:

=IF(OR(G$3=$B7,G7+F7=$C$2),$C$2,0)

which is correct, but I need to add to that formula, "unless C5=0, in that case return 0)

My attempts look like this:

=IF(ISNUMBER(D5=0),0,(OR(F$3=$B5,F5+E5=$C$2),$C$2,0)

Thanks

 

[Andrew Poulsom]

Welcome to MrExcel.

Is it?

=IF(AND($C$5<>0,OR(G$3=$B7,G7+F7=$C$2)),$C$2,0)

 

[Captain Hindsight]

Fantastic!

Thank you very much, I had spent some time trying to do that with limited success.