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.
|