Eliminate #DIV/0! with IFERROR

[DJPaton]

Hi there

I'm having a brain freeze with an IFERROR to eliminate the #DIV/0! after a simple calculation and it's driving me insane... the formula is =(E108-C108)/C108 the result of course where there are zeros is #DIV/0!. I have tried a few variations unsuccessfully any help will be greatly appreciated!

 

[Peter_SSs]

I wouldn't use IFERROR for that but rather

=IF(C108=0,"whatever you want instead of the div error",(E108-C108)/C108)

 

[mohadin]

What about

=IF(C108<>0,(E108-C108)/C108,"")

 

[DJPaton]

Excellent suggestions both work perfectly thank you Peter-Sss and mohadin very much!

 

[mohadin]

Glade we Gould help
Be happy