Formula problem
 

currently I am using this formula =IF(H330,(H33*N33)-R33,"") I works good,
but if I enter H33=0 and N33=0% R33=0 I want the result to be 0, and also
keep the formula showing only if I have number on H33.

How can I solve this problem

Formula problem
 

=IF(H33="","",IF(AND(H33=0,N33=0,R33=0),0,(H33*N33 )-R33))
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Frances C" wrote:

currently I am using this formula =IF(H330,(H33*N33)-R33,"") I works good,
but if I enter H33=0 and N33=0% R33=0 I want the result to be 0, and also
keep the formula showing only if I have number on H33.

How can I solve this problem

Formula problem
 

Won't simply =IF(H33=0,(H33*N33)-R33,"") do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Frances C" wrote in message
...
currently I am using this formula =IF(H330,(H33*N33)-R33,"") I works
good,
but if I enter H33=0 and N33=0% R33=0 I want the result to be 0, and also
keep the formula showing only if I have number on H33.

How can I solve this problem

Formula problem
 

I'm not exactly sure what you want, but this might be it:
=IF(ISNUMBER(H33),IF(H33=0,(H33*N33)-R33,""),"")

"Frances C" wrote in message
...
currently I am using this formula =IF(H330,(H33*N33)-R33,"") I works
good,
but if I enter H33=0 and N33=0% R33=0 I want the result to be 0, and also
keep the formula showing only if I have number on H33.

How can I solve this problem