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

Error Messages
 

Use ISERROR formula within IF
eg.
=IF(ISERROR(B1/C1),"",B1/C1)

general forms is
=IF(ISERROR(your formula),"Result if formula gives error",your formula)

"msao" wrote:

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

Error Messages
 

I don't understand what you are trying to do with =SUM(Q39*144/V39)
What do you want the SUM function to add to Q39*144/V39 ?
Or did you intend your formula to be just =Q39*144/V39 ?
If you need help on what the SUM function in Excel does, look up SUM in
Excel help.

If you want the result to be blank if V39 is blank, try
=IF(V39="","",Q39*144/V39)
If you want it to be blank if either V39 or Q39 is blank, try
=IF(COUNT(V39,Q39)=2,Q39*144/V39,"")
--
David Biddulph


"msao" wrote in message
...
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

Error Messages
 

If V39 will always have numerics then
=IF(V39,Q39*144/V39,"")

'if V39 can contain text and numerics then
=IF(AND(ISNUMBER(V39),V390),Q39*144/V39,"")

same with R39


If this post helps click Yes
---------------
Jacob Skaria


"msao" wrote:

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

Error Messages
 

it is u39 that will recive the sum changed it to the fist one below would not
work

"Jacob Skaria" wrote:

If V39 will always have numerics then
=IF(V39,Q39*144/V39,"")

'if V39 can contain text and numerics then
=IF(AND(ISNUMBER(V39),V390),Q39*144/V39,"")

same with R39


If this post helps click Yes
---------------
Jacob Skaria


"msao" wrote:

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