Iserror??

[redlion3]

Hi,

I am trying to make the formula below have an iserror ref. If the "E27" has nothing in it ( or a formula that is calculating nothing) how would i do that?

=IF(E27=0,F27*2080,E27)

[oldchippy]

Hi,

I am trying to make the formula below have an iserror ref. If the "E27" has nothing in it ( or a formula that is calculating nothing) how would i do that?

=IF(E27=0,F27*2080,E27)

=if(iserr(Your formula)),"",Your formula)

[daddylonglegs]

Try

=IF(E27="","",IF(E27=0,F27*2080,E27))

[redlion3]

Awesome - that worked!

Thank you!

[oldchippy]

Glad it worked for you - thanks for the feedback