Hi,
How can I fix the formula so it will not display?
Thanks,
RO
2006-09-11 02:22:21 · 4 answers · asked by rgombina 2 in Computers & Internet ➔ Programming & Design
Sorry, I am using a DATE() function but the cell evaluated is empty or blank. I am dragging the formula across so in case there is a value to evaluate. Thanks.
2006-09-11 02:32:12 · update #1
I found out the answer:
ISERROR is the key.
2006-09-11 03:37:34 · update #2
This is the way I would set up that formula:
=IF(ISERROR(
DATE(B1,C1,D1)),"",
DATE(B1,C1,D1))
2006-09-11 08:59:43 · answer #1 · answered by Ken C. 6 · 0⤊ 0⤋
Without seeing the formula I can't tell you what's wrong with it.
This happens a lot when the cell isn't big enough to display the result, a date won't fit the cell, division by zero, integer out of range, stuff like that.
2006-09-11 09:26:50 · answer #2 · answered by Anonymous · 0⤊ 0⤋
You have to enter a value for the formula. The only way to make this go away is by entering a value for the formula to calculate.
2006-09-11 09:31:01 · answer #3 · answered by rhutson 4 · 0⤊ 0⤋
Adjust the column width to be wider.
2006-09-11 09:26:29 · answer #4 · answered by Thor 5 · 0⤊ 1⤋