| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formulas?
I'm trying to create a formula to give me the following:
$1.00-30.00=1.46 30.01-60.00=4.35 60.01-89.00=8.70 89.01-119.00=12.16 119.01-147.00=19.54 147.01-178.00=23.88 178.01-206.00=28.22 206.01-236.00=32.56 236.01-295.00=39.07 295.01-354.00=54.11 354.01-413.00=75.23 413.01-471.00=86.81 741.01-530.00=122.98 530.01-590.00=130.22 Can anyone help??...Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Threaded Mode
