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

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

Try

=IF(L2<25,L2*0.52,L2*0.1)

Regards
Rowan

"RickyBubbalu" wrote:

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

an alternative with no IF

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

--

HTH

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


"Rowan" wrote in message
...
Try

=IF(L2<25,L2*0.52,L2*0.1)

Regards
Rowan

"RickyBubbalu" wrote:

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