B Bob Westaby Apr 15, 2004 #1 How do I write a formula for comparing a1>b1, and then subtracting b1 if a1 is greater?.
B BrianB Apr 16, 2004 #3 The general formula is :- =IF(value1 > value2, result if true, result if false) '------------------------------------------------------- This uses your criteria, If A1>B1 *then* result = A1 - B1 *otherwise* result = 0 =IF(A1>B1,A1-B1,0) '-------------------------------------------------------
The general formula is :- =IF(value1 > value2, result if true, result if false) '------------------------------------------------------- This uses your criteria, If A1>B1 *then* result = A1 - B1 *otherwise* result = 0 =IF(A1>B1,A1-B1,0) '-------------------------------------------------------
