Have Blank Cell instead of a Cell that has a value of 0

[Bobby82]

Hello,

What I am trying to accomplish is this if the cell that I am using as a reference has no data inputted into it the cell that I have the formula returns me a value of 0 I want it to be blank if it has a value of 0 for organization purposes

example: (Cell A51)=IFERROR($J$45/$J$3*A10,"")*($C$47/$C$5) and also this formula (Cell C51)=IFERROR(C9,"")

[mehmetcik]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[boopathiraja]

May be this in A51

Please Login or Register  to view this content.

[Bobby82]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you worked great

If I may ask why is this one returning and error for me it is in D51 =IFERROR(A51/C51,"")

[mehmetcik]

try:

Please Login or Register  to view this content.