Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula Problem need help | Excel Worksheet Functions | |||
Formula problem | Excel Discussion (Misc queries) | |||
formula problem | New Users to Excel | |||
Formula Problem | New Users to Excel |