Turn off error display in excel??? 5

[NerdTop72]

Is there a way to turn off the error display in excel when no info is added to a cell yet?
the error in a cell #DIV/0!
i want to calculate a cell when there is only info in the cells that need to be calculated...
here is my cell with the error
=H8/F8
thanks

 

[AnotherHiggins]

=If(iserror(H8/F8),"",H8/F8)

or

=if(F8=0,"",H8/F8)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[KenWright]

=IF(F8=0,0,H8/F8)

or

=IF(F8=0,"",H8/F8)

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[xlhelp]

Or for the fun of it you can leave the errors as they are and highlight the cells with the formulas, set the font to white; then format the cells with [black]#,##0_);[red](#,##0) etc. This way erros will still exist they will not show and any valid result will.

[COLOR=blue white]I am posting this, just as an alternative that exists.
My preference is to go with what Messers Higgins and Wright have suggested.[/color]

Member- AAAA Association Against Acronym Abusers

 

[NerdTop72]

Thanks

 

[Rofeu]

I like your solution, xlhelp!

Specifically useful when working with graphs --> #N/A is still there, so you're line isn't dropping to zero, but the user sees a blank cell! Have another star.

Cheers,

Roel