# Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

1. ## Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

If column N "Resolution Date" is blank, result is blank
If Column N is not blank, then subtract Resolution Date from Colum M" Submit Date" result is Days to Approve

This formula has been working, but isn't working today
=IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

(Computer upgraded to Win 10 & Office 2013 (not sure if this made a difference or not)

Column M N O
Label Submit Date Resolution Date Days to Approve
Sample1 2/16/17 2/16/17 0
Sample 2 2/6/17 blank blank
Sample 3 2/6/17 2/7/17 2

2. ## Re: Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

Not sure why double this IF(ISBLANK(N4),"",IF(ISBLANK(N4)
Try this one
Formula:
`Please Login or Register  to view this content.`

You may also try these two
Formula:
`Please Login or Register  to view this content.`

or
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

What I see is that the formula is checking N4 twice, which seems odd, is it supposed to check N then M?
When you say "is not working" what do you mean exactly? formula returns an error, does not put blank when N4 is blank, doesn't do the subtraction....

4. ## Re: Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

That worked

I figure someone messed with the formula, but I couldn't remember what the original formula was

Thanks a bunch!!!

5. ## Re: Formula not working =IF(ISBLANK(N4),"",IF(ISBLANK(N4),"",N4-M4))

Glad it was sorted, I'm assuming AlKey's post is the one that did it. If the issue is fixed please remember to mark the thread as solved? Thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1