| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
returning calculation based on number
in one column, we have retail list. I want to set a formula so that
if price <= 49.99 it equals the list if price 50-100 it equals 10% off if price is 100+ it equals 20% off. i've researched a lot in excel, and can't figure out how to setup this formula... please advise. Thanks Brad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a value in one cell based on the criteria of another cel | Excel Worksheet Functions | |||
| Nested If statements returning a sum calculation | Excel Worksheet Functions | |||
| Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
| returning a value based on mulitple criteria | Excel Worksheet Functions | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
