if then function
In an if then statement, how do I get the value to be a
result for instance If b12b13, then b12*5% |
hi,
=if(condition, true, false) =if(B12B13,B12*.05,something else) -----Original Message----- In an if then statement, how do I get the value to be a result for instance If b12b13, then b12*5% . |
-----Original Message----- In an if then statement, how do I get the value to be a result for instance If b12b13, then b12*5% . I had this problem which i eventually solved my slef using this =IF(C5C6,C37,IF(C5<C6,C6-C5,IF(C5=0,C8+C9+C10+C12))) so in answer to your question =IF(B12B13,B12*5%) |
All times are GMT +1. The time now is 10:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com