Show Blank instead of Zero

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!