[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Formula help please

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
snyperj
Asked:
snyperj
1 Solution
 
cyberkiwiCommented:
=IF(IF(""=I16&"",$N$10,I16)<$N$10,M16,0)
0
 
barry houdiniCommented:
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
 
ragnarok89Commented:
=if(isnull(I16),0,IF(I16<$N$10,M16,0))

or

=if(I16="",0,IF(I16<$N$10,M16,0))
0
 
snyperjAuthor Commented:
this one was first and worked for me- so thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now