So I have two formulas in a spreadsheet and I need to combine them. I'm stuck.
Formula 1 - IFERROR(IF(TODAY()-E93<21,"NO","ESCALATE"),"")
Formula 2 - IF(O92=100,"COMPLETE")
I'm figuring this is a rather simple fix, but I'm just rackin my brain and failing...
Thank you for any and all help!
Maybe this
Formula:
=IFERROR(IF(O92=100,"COMPLETE",IF(TODAY()-E93<21,"NO","ESCALATE")),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I knew I'd feel dumb afterwards. So simple.
Thank you AlKey!!! Added Rep for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks