IF ERROR Formula

  • Thread starter Thread starter Denver
  • Start date Start date
D

Denver

=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1))))

I have this formula in my worksheet but a message box pop up
......The formula you type contains error and it highlights the formula ""


do i miss something here? thanks for any help, I appreciate.
 
What version of Excel are you using? When I enter your formula in 2007, I
get no error. It looks to me like you allowed Excel to correct the error.

Regards,
Fred.
 
Hi,

It worked fine in Excel 2003. If it is highlighting the "" is usually means
that they aren't "" instead they are four single quotes or they are Word's
special quotes.
 
The formula looks OK. Perhaps your settings are expecting a semi-colon
instead of a comma as a list separator?
 
I am using Excel 2003

Fred Smith said:
What version of Excel are you using? When I enter your formula in 2007, I
get no error. It looks to me like you allowed Excel to correct the error.

Regards,
Fred.
Click to expand...
 
Back
Top