what do I do so a will get "0" if the answer is less than zero such as 5 - 6 and it give me "0"
P Phillip Devoll Oct 23, 2004 #1 what do I do so a will get "0" if the answer is less than zero such as 5 - 6 and it give me "0"
V VENKAT Oct 23, 2004 #2 your reequiremnt is not clear. however use tis formula in any cell suppose a1 is 5,a2 is 6 type this in any other cell =IF(A1-A2<0,0,A1-A2) =======================
your reequiremnt is not clear. however use tis formula in any cell suppose a1 is 5,a2 is 6 type this in any other cell =IF(A1-A2<0,0,A1-A2) =======================
