Posted to microsoft.public.excel.worksheet.functions

msao

external usenet poster

Posts: 9

Error Messages

i have a cell that draws information from the sheets that have not been
filled in yet and i recive #N/A i would like to recive nothing in that cell.
=SUM(Q39*144/V39)
In a nother sell i recive #DIV/0! The formula is
=((0.109136*(Q39^1.9))/R39)^(1/5.02)
if the imformation is not avalible would like it blank any help with this
would be great

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error messages	DAE	Excel Discussion (Misc queries)	6	June 12th 09 09:21 PM
Name error messages...	Corkey	Excel Worksheet Functions	3	December 31st 07 07:11 PM
Error Messages	Kathy	Excel Discussion (Misc queries)	9	May 16th 06 03:01 PM
error messages	bf	Excel Discussion (Misc queries)	2	April 12th 06 03:15 AM
Error Messages	mikel2634	Excel Worksheet Functions	0	May 21st 05 04:30 PM

All times are GMT +1. The time now is 11:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us