WS attached
B9 through P9 is where the formula needs to go.
Basically anytime the remaining total in B9:P9 is a negative,
I just want it to show 0 as the remaining.
As you can see from the WS B9, D9 and F9 are showing negative numbers.
Once it hits 0 I want it to stay at 0.
Thank You
try =IF((B7-B8)<=0,0,B7-B8)
or
=IF(AND(B7="",B8=""),"",IF((B7-B8)<=0,0,B7-B8))
Last edited by sandy666; 03-12-2017 at 11:10 AM.
1st one works fine, thank you!
If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you)
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks