# 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

##### Users Browsing this Thread

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