Forecast IF Error Formula
Hi,
Try this
=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF 1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($A F1:AH1)))
)
Mike
"Denver" wrote:
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
|