It's been awhile with If clauses, but I can't seem to get this to work. What I'm basically trying to do is
If E2+F2+G2 is greater than or = D2, then enter 0. If its less D2, then enter the difference between the sum of E2, F2 and G2, and D2.
How should this read?
Thanks so much for your help.
Try
=IF(E2+F2+G2>=D2,0,D2-(E2+F2+G2))
or
=IF(E2+F2+G2>=D2,0,E2+F2+G2-D2)
depending on which way around you want to perform the difference calculation.
Martin
Maybe..
=MAX(0,D2-SUM(E2:G2))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks