Thread
:
I need the cell to read 0
View Single Post
#
5
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
I need the cell to read 0
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!
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann