| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help
If my target cell is less than a specific number I want to multiply it by a
certain rate and if it's greater than this specific number I want to multiply it by a different rate. If someone could write down a sample formula I think I can figure it out. thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula help
If target cell is A1, multiplication factor in B1 and C1, number to check in
D1 then enter this in E1 =IF(D1=A1,D1*B1,D1*C1) "MHS" wrote: If my target cell is less than a specific number I want to multiply it by a certain rate and if it's greater than this specific number I want to multiply it by a different rate. If someone could write down a sample formula I think I can figure it out. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
