Captain Hindsight
New Member
- Joined
- Oct 9, 2013
- Messages
- 46
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
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