Error Messages

[msao]

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

 

[Sheeloo]

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)

 

[David Biddulph]

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,"")

 

[Jacob Skaria]

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

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

same with R39


If this post helps click Yes

 

[msao]

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