Forecast IF Error Formula

  • Thread starter Thread starter Denver
  • Start date Start date
D

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
 
Hi,

Try this

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

Mike
 
=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
 
Back
Top