if then function

[rhonda.walter]

In an if then statement, how do I get the value to be a
result for instance If b12>b13, then b12*5%

 

[Guest]

hi,
=if(condition, true, false)
=if(B12>B13,B12*.05,something else)

 

[Larry harman]

-----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%
.

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%)