Ignore 0

[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

[andy_hammer2001(remove)]

Shhhh wrote:

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

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.

[Shhhh]

Perfect!!

Thank you so much,
Shhhh

"andy_hammer2001(remove)" <"andy_hammer2001(remove)"@yahoo.com.au> wrote in
message news:[email protected]...
> Shhhh wrote:
>
>> 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
>
> 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.