cell formula question
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! |
cell formula question
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! |
cell formula question
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 - |
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 - |
cell formula question
Robert,
This will return a blank cell unless both cells have a number in =IF(COUNT(C1,D2)=2,C1/D2,"") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "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! . |
All times are GMT +1. The time now is 05:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com