A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

#DIV/0!



 
 
Thread Tools Display Modes
  #1  
Old December 26th, 2007, 06:48 PM posted to microsoft.public.excel.worksheet.functions
pal
external usenet poster
 
Posts: 209
Default #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  
Old December 26th, 2007, 06:54 PM posted to microsoft.public.excel.worksheet.functions
joeu2004
external usenet poster
 
Posts: 1,748
Default #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  
Old December 26th, 2007, 06:56 PM posted to microsoft.public.excel.worksheet.functions
bj
external usenet poster
 
Posts: 1,451
Default #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  
Old December 26th, 2007, 06:57 PM posted to microsoft.public.excel.worksheet.functions
Ron Coderre
external usenet poster
 
Posts: 1,922
Default #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  
Old December 26th, 2007, 08:47 PM posted to microsoft.public.excel.worksheet.functions
JP[_5_]
external usenet poster
 
Posts: 559
Default #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  
Old December 26th, 2007, 10:01 PM posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
 
Posts: 3,722
Default #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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.