How to make a formula with < or> in a cell

R

RickyBubbalu

I am trying to make a formula that does this:

If the amount of L2 is less than $25, times it by .052; if the amount of L2
is $25 or above, times it by .01
 
B

Bob Phillips

an alternative with no IF

=A1*0.01+(A1<25)*A1*0.042

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top