Forum Discussion
Creasting a formula in Exce
I want cell G5=G5*F2 unless J5=F5 then G5 should be 0
4 Replies
A formula in G5 cannot refer to G5 itself - that would cause a circular reference.
- Sorry, The formula for Cell G5 is: G2*F5
But if J5 is equal to F5 then I want G5 to be 0
Does that make sense now? If so what would that formula be for cell G5?In G5:
=IF(J5=F5,0,G2*F5)
If you use comma as decimal separator, the formula should be
=IF(J5=F5;0;G2*F5)
