Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple SumIF Question?
Hello, I am having trouble with a SumIf question that I think would be simple
but doesn't seem to work. Basically I am just dividing two columns but when there is a zero, it gives me the div/o error message. Here is my current calculation: =H3/G3 What I would like is that if H3 is zero then to just return a zero but to do the division if H3 is greater than zero. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple SumIF Question?
Try
=IF(ISERROR(H3/G3),0,H3/G3) "RoadKill" wrote: Hello, I am having trouble with a SumIf question that I think would be simple but doesn't seem to work. Basically I am just dividing two columns but when there is a zero, it gives me the div/o error message. Here is my current calculation: =H3/G3 What I would like is that if H3 is zero then to just return a zero but to do the division if H3 is greater than zero. Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple SumIF Question?
RoadKill
Don't you mean if G3 is zero? If H3 is 0, you should get 0, but you will get a divide by 0 error if G3 is 0. =If(G3=0,0,H3/G3) HTH, Conan "RoadKill" wrote in message ... Hello, I am having trouble with a SumIf question that I think would be simple but doesn't seem to work. Basically I am just dividing two columns but when there is a zero, it gives me the div/o error message. Here is my current calculation: =H3/G3 What I would like is that if H3 is zero then to just return a zero but to do the division if H3 is greater than zero. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple SUMIF, I think... | Excel Worksheet Functions | |||
SUMIF - really simple, but beats me - help! | Excel Discussion (Misc queries) | |||
this may be simple, sumif question | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) |