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
|