Ignore #VALUE Error

[counihan3]

I am putting several formuals together, I have one formula that is causing the problem. Is there something that I can put infront of the formula such as ISERROR, to keep that value from returning.

 

[venkat1926]

if(iserror(your formula),"",yourformula)

this means if the formula is giving an error the cell will be blank.

 

[Brian from Maui]

I am putting several formuals together, I have one formula that is causing the problem. Is there something that I can put infront of the formula such as ISERROR, to keep that value from returning.

What is the formula that is causing the #VALUE error?

 

[venkat1926]

see under excel sheet help "Correct a #VALUE! error"

there reasons for this error are given