I have two data fields and I'm trying to use IF to display a zero if the sum is less than 1. But I want the sum shown if result is greater than zero. How do I write the formula?
For example: =IF(B4-C4)<1,0 That works to show zero but I can't figure out how to add that I want the sum shown if the sum is greater than 0.
Please help!!
Alan
Like this?
Formula:
Please Login or Register to view this content.
BSB
try =if(b4-c4>=1,b4-c4,0) That will show a zero for anything including blank cells.
however, you have b4-c4 but you are discussing "sum" so shouldn't it be b4+c4?
if so then change the formula to =if(b4+c4>=1,b4+c4,0)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you SO MUCH!!!
you are welcome. and if that takes care of it for you then don't forget to mark the post as solved using the thread tools dropdown at the top of this post.
BTW, which did you use?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks