| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Calculation
I need a calculation to do the following; If the value entered is above
£49.99 I need it to show 6% of £39.99. If the value entered in the cell is less than £49.99 I need it to show 6% of the value entered less £10.00. i.e. if over £49.99 it would show £2.40 if the value was £44.99 I would need it show 6% of £34.99 How can I do this? Any help would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Calculation of After tax Cost of debt Plz Help | Excel Worksheet Functions | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| Formula calculation in a Shared Excel File | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
