Hello all,
I have 5 sheets. I have used the following formula to show Blank instead of Zero in Sheet2.
=IF('Sheet1'!A5+'Sheet1'!A7)="0","",('Sheet1'!A5+'Sheet1'!A7))
Where, in Sheet1, A5 is a value entered and A7=A5+A6
But with this formula I get the value '0.00' in Cell B3 in Sheet2.
Could you help me as to how to get Blank cell instead of Zero in Sheet2 in Cell B3
Thank you all for your kind help.