The formula below works perfectly that is in cell U594
But I want to add another condition to it
=IF(S594="Pending",IF(O594="",TODAY()-P594,TODAY()-O594),"")
I want to add the condition that if A594 is blank then cell U594 is blank
This new condition needs to operate first before the remaining formula is performed.
Like this...
=IF(A594="","",IF(S594="Pending",IF(O594="",TODAY()-P594,TODAY()-O594),""))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks Tony, that did it
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks