In an if then statement, how do I get the value to be a result for instance If b12>b13, then b12*5%
R rhonda.walter Feb 11, 2005 #1 In an if then statement, how do I get the value to be a result for instance If b12>b13, then b12*5%
L Larry harman Feb 11, 2005 #3 -----Original Message----- In an if then statement, how do I get the value to be a result for instance If b12>b13, then b12*5% . Click to expand... I had this problem which i eventually solved my slef using this =IF(C5>C6,C37,IF(C5<C6,C6-C5,IF(C5=0,C8+C9+C10+C12))) so in answer to your question =IF(B12>B13,B12*5%)
-----Original Message----- In an if then statement, how do I get the value to be a result for instance If b12>b13, then b12*5% . Click to expand... I had this problem which i eventually solved my slef using this =IF(C5>C6,C37,IF(C5<C6,C6-C5,IF(C5=0,C8+C9+C10+C12))) so in answer to your question =IF(B12>B13,B12*5%)
