Is there a way to a formula that would show the following?
A plus B = C but if A is below 0, stop the value at 0 then add column B:
Columns:
A B C
-2 5 5
1 5 6
0 5 5
Any help would be greatly appreaciated. Thanks!
Is there a way to a formula that would show the following?
A plus B = C but if A is below 0, stop the value at 0 then add column B:
Columns:
A B C
-2 5 5
1 5 6
0 5 5
Any help would be greatly appreaciated. Thanks!
Last edited by PowerSchoolDude; 10-27-2009 at 02:24 PM.
In C1
=MAX(0,A1)+B1
You rock. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks