cell formula question
Another way but only if all users have 2007+
=IFERROR(A1/B1,"")
in 97-2003 use ISERROR as suggested by jkrons
Regards,
Peter T
"jkrons" wrote in message
...
Actually
=IF(ISERROR(C1/D2;"";C1/D2)
is better
On 18 Maj, 11:16, jkrons wrote:
Try =IF(ISNA(C1/D2;"";C1/D2)
Jan
On 18 Maj, 10:08, "Robert Crandal" wrote:
I am using the following formula in one of my cells: "=C1 / D2".
The problem with this formula is that the result will be "#DIV/0!"
if cell D2 contains no data.
Can I somehow fix my formula so it does NOT return any value
if either C1 or D2 is empty? I just want to avoid situations when
the outuput of my formula is "#DIV/0!" or "#Value#" because it
just doesn't look pretty to me, hahah!
Thank you!- Skjul tekst i anførselstegn -
- Vis tekst i anførselstegn -
|