Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it
gives me a #div! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
Try:
=IF(G3=0,0,AM3/G3) Note: no need for the SUM() function. or: =IF(G3=0,"",AM3/G3) To return an empty looking cell instead of a zero. If there is any chance that G3 may contain an empty string, (from a formula) then use: =IF(OR(G3=0,G3=""),"",AM3/G3) HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Peter" wrote in message ... I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it gives me a #div! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
try this =IF(ISERROR(SUM(AM3/G3)),0,SUM(AM3/G3))
On Jun 1, 11:48*pm, Peter wrote: I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it gives me a #div! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
That worked thanks, it helped alot. However what if I have a formula that
reads =(e34+h34)/j26. How do I get the ) in that formula? "Sandy Mann" wrote: Try: =IF(G3=0,0,AM3/G3) Note: no need for the SUM() function. or: =IF(G3=0,"",AM3/G3) To return an empty looking cell instead of a zero. If there is any chance that G3 may contain an empty string, (from a formula) then use: =IF(OR(G3=0,G3=""),"",AM3/G3) HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Peter" wrote in message ... I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it gives me a #div! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
I have the formula
=(e34+h34)/j26 it gives me the #div0! error. I want it to read 0 "Sandy Mann" wrote: I don't understand what you mean by: reads =(e34+h34)/j26. How do I get the ) in that formula? ) ?? -- Regards Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Peter" wrote in message ... That worked thanks, it helped alot. However what if I have a formula that reads =(e34+h34)/j26. How do I get the ) in that formula? "Sandy Mann" wrote: Try: =IF(G3=0,0,AM3/G3) Note: no need for the SUM() function. or: =IF(G3=0,"",AM3/G3) To return an empty looking cell instead of a zero. If there is any chance that G3 may contain an empty string, (from a formula) then use: =IF(OR(G3=0,G3=""),"",AM3/G3) HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Peter" wrote in message ... I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it gives me a #div! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
muddan
ISERROR will hide all errors and would also hide a #VALUE! error if G3 contained a <space OP wants just the #DIV0! trapped. See Sandy's suggestions. Gord Dibben MS Excel MVP On Sun, 1 Jun 2008 12:02:42 -0700 (PDT), muddan madhu wrote: try this =IF(ISERROR(SUM(AM3/G3)),0,SUM(AM3/G3)) On Jun 1, 11:48*pm, Peter wrote: I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it gives me a #div! |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
Just the same as befo
=IF(J26=0,0,(E34+H34)/J26) or: =IF(OR(J26=0,J26=""),"",(E34+H34)/J26) depending of what may be in J26. If only ever a BLANK cell or a number then the first one. If J26 *may* contain an empty string, (for instance if J26 had a forrmula like: =IF(J16="","",10) which will return "" or 10) then use the second one. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Peter" wrote in message ... I have the formula =(e34+h34)/j26 it gives me the #div0! error. I want it to read 0 "Sandy Mann" wrote: I don't understand what you mean by: reads =(e34+h34)/j26. How do I get the ) in that formula? ) ?? -- Regards Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Peter" wrote in message ... That worked thanks, it helped alot. However what if I have a formula that reads =(e34+h34)/j26. How do I get the ) in that formula? "Sandy Mann" wrote: Try: =IF(G3=0,0,AM3/G3) Note: no need for the SUM() function. or: =IF(G3=0,"",AM3/G3) To return an empty looking cell instead of a zero. If there is any chance that G3 may contain an empty string, (from a formula) then use: =IF(OR(G3=0,G3=""),"",AM3/G3) HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Peter" wrote in message ... I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it gives me a #div! |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need the cell to read 0
Thanks everyone it helped!!!
"Gord Dibben" wrote: muddan ISERROR will hide all errors and would also hide a #VALUE! error if G3 contained a <space OP wants just the #DIV0! trapped. See Sandy's suggestions. Gord Dibben MS Excel MVP On Sun, 1 Jun 2008 12:02:42 -0700 (PDT), muddan madhu wrote: try this =IF(ISERROR(SUM(AM3/G3)),0,SUM(AM3/G3)) On Jun 1, 11:48 pm, Peter wrote: I have this formula =SUM(AM3/G3) I need the cell to read zero, right now it gives me a #div! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to read the value of a cell | Excel Worksheet Functions | |||
How to use If statement to read a value in a cell | Excel Discussion (Misc queries) | |||
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
"read only" cell in a given worksheet | Excel Discussion (Misc queries) |