=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF 1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($A F1: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.

"Denver" wrote in message
...
=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF 1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($A F1: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.

I am using Excel 2003

"Fred Smith" wrote:

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.

"Denver" wrote in message
...
=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF 1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($A F1: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.

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Denver" wrote:

=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF 1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($A F1: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.