Forecast IF Error Formula

[Denver]

Hi,

I have this formula in my excel worksheet
FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))

I want to add the IF(ISError) formula from the above forecast formula
what could be look like? I was not succesful in my attempts, it asking me
the (Value) (Value_IF_true) etc...

thanks for any help

 

[Mike H]

Hi,

Try this

=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))
)

Mike

 

[Denver]

=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1))))

i have try working on the formula but a message box pop up,
The formula you type contains error and it highlights the formula ""

what else do i miss? thanks again for any help