Thread
:
Formula problem
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann