IF ERROR Formula
=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. |
IF ERROR Formula
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. |
IF ERROR Formula
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. |
IF ERROR Formula
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. |
All times are GMT +1. The time now is 01:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com