Problem with "IF" function
Well, I just tested some more, and I just found out that it DOES work, but it
works the wrong way, i.e. it gives the output "PENDING" for the first 60 days
AFTER the expiry date, not before as it is supposed to.
What could be the reason for this?
Best regards,
Torfinn
"Torfinn Brokke" wrote:
Hello, Pete!
Thank you very much! I just tried your suggestion, but for some reason it
still doesn't seem to work... Could there be something wrong with the formula
I've put in?
Best regards,
Torfinn
|