| 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 | |||
Linear Mode
