Solved

Posted on 2011-02-16
Medium Priority
243 Views
In the below formula:

=IF(I16<\$N\$10,M16,0)

I16 is a date field and N10 is a date field.

How can I adjust the formula so that if I16 is null, a zero is also returned.  Right now it returns the value of M16 when null.    Thanks
0
Question by:snyperj
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 58

Accepted Solution

cyberkiwi earned 2000 total points
ID: 34910152
=IF(IF(""=I16&"",\$N\$10,I16)<\$N\$10,M16,0)
0

LVL 50

Expert Comment

ID: 34910731
Use an AND to test for both conditions, I16 < N10 and I16 isn't blank

=IF(AND(I16<>"",I16<\$N\$10),M16,0)

regards, barry
0

LVL 8

Expert Comment

ID: 34910757
=if(isnull(I16),0,IF(I16<\$N\$10,M16,0))

or

=if(I16="",0,IF(I16<\$N\$10,M16,0))
0

Author Closing Comment

ID: 34910798
this one was first and worked for me- so thanks!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
###### Suggested Courses
Course of the Month15 days, 2 hours left to enroll