| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if value is greater than # * by 20% if less * by 40
Try this:
For A1: (a price) The marked up price B1: =A1*IF(A130,1.2,1.4) Does that help? *********** Regards, Ron XL2002, WinXP "sypher" wrote: if price is higher than 30 dollars markup by 20% if less than 30$ markup by 40% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Values from an Array | Excel Worksheet Functions | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions | |||
Hybrid Mode
