Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Error | Excel Worksheet Functions | |||
Sum Formula Error | Excel Discussion (Misc queries) | |||
Error in my formula? | Excel Discussion (Misc queries) | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Formula error... | Excel Discussion (Misc queries) |