If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#DIV/0!
I have a table that is performing a lot of calculations. Because there is no
data yet to complete the formula I get the "#DIV/0!" error. Is there a way to hide this until there is a data. |
#2
|
|||
|
|||
#DIV/0!
On Dec 26, 9:48*am, PAL wrote:
I have a table that is performing a lot of calculations. *Because there is no data yet to complete the formula I get the "#DIV/0!" error. *Is there a way to hide this until there is a data. =if(A1="", "", B1/A1) |
#3
|
|||
|
|||
#DIV/0!
=if(iserror(your formula),"",your formula)
"PAL" wrote: I have a table that is performing a lot of calculations. Because there is no data yet to complete the formula I get the "#DIV/0!" error. Is there a way to hide this until there is a data. |
#4
|
|||
|
|||
#DIV/0!
Here are a couple options....
For values in A1 and B1 C1: =IF(B1=0,0,A1/B1) or C1: =IF(B1=0,"n/a",A1/B1) Does that help? Post back if you have more questions. -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "PAL" wrote in message ... I have a table that is performing a lot of calculations. Because there is no data yet to complete the formula I get the "#DIV/0!" error. Is there a way to hide this until there is a data. |
#5
|
|||
|
|||
#DIV/0!
How about
=IF(ISBLANK(first cell),"",your_formula) ex: =IF(ISBLANK(A1),"",B1/A1) This would having Excel perform your calculations twice (if the cell isn't blank). HTH, JP On Dec 26, 12:48*pm, PAL wrote: I have a table that is performing a lot of calculations. *Because there is no data yet to complete the formula I get the "#DIV/0!" error. *Is there a way to hide this until there is a data. |
#6
|
|||
|
|||
#DIV/0!
=IF(A1,B1/A1,"")
"PAL" wrote: I have a table that is performing a lot of calculations. Because there is no data yet to complete the formula I get the "#DIV/0!" error. Is there a way to hide this until there is a data. |
Thread Tools | |
Display Modes | |
|
|