IF ERROR Formula

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

Fred Smith

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

Shane Devenshire

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

David Biddulph

The formula looks OK. Perhaps your settings are expecting a semi-colon
instead of a comma as a list separator?
 
D

Denver

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forecast IF Error Formula 2
sumproduct and weekday? 19
simplify formula 7
How do I make a cell blank if Error OR 0 Result 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
if(and(isblank( formula help 2
Help with an Indirect formula to reference sheet names 4
Excel VBA 1

Top