Iferror

[pooley100777]

Hi all,

This is a really simple question but for some reason i cant get it to work.

I have the following formular =IF(Fcast!D10>0,SUM(Fcast!D10-Budget!D10),0) and i want to add an (iferror) to it but i cant seen to get it to work?

I need the iferror value to enter a zero if the above formular hasen got a value in the Fcast spreadsheet as in the sheet it is bring back a #value cell. so all the #values cells i need to change to 0.

Hope this make sense?

Many thankss for you help

M

 

[salfordchameleon]

does =IFERROR(IF(Fcast!D10>0,SUM(Fcast!D10-Budget!D10),0),"ERROR") work ?

Where ERROR is in the formula type in whatevere you the cell to say.

 

[pooley100777]

Yes it does and this is what i have been scratching my head over for the past hour!

Thankyou so much, i have tried every other way apart from that one. I thinks its time i went home.

Thanks again!

 

[salfordchameleon]

No Probs.

thanks for replying.