Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula HELP | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
FORMULA TO MAKE CELL COLOR CONTINGENT | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |