Ignore 0

  • Thread starter Thread starter Shhhh
  • Start date Start date
S

Shhhh

Hello all,

how can I come up with a formula where one worksheet is pulling data from
another worksheet, and leaves the cell blank if the data is a 0... anything
other than a 0 is ok, but not 0s.

BTW the data is in currency format, no $ symbol but 0.00.

Thank you all so much,
Shhhh
 
Shhhh said:
Hello all,

how can I come up with a formula where one worksheet is pulling data from
another worksheet, and leaves the cell blank if the data is a 0... anything
other than a 0 is ok, but not 0s.

BTW the data is in currency format, no $ symbol but 0.00.

Thank you all so much,
Shhhh
Click to expand...

Hi

Do you require something along the lines of:

=IF(A1=0,"","Do Something")

Basically if Cell A1 is 0.00 then Leave blank, if cell A1 is not 0 then
do the calculation.
 
Perfect!!

Thank you so much,
Shhhh

andy_hammer2001(remove) said:
Hi

Do you require something along the lines of:

=IF(A1=0,"","Do Something")

Basically if Cell A1 is 0.00 then Leave blank, if cell A1 is not 0 then do
the calculation.
Click to expand...
 
Back
Top