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