| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Assign a dollar amount to a corresponding number in a range of num
I have a column listing a number in a range of 1 through 70. I need to
create a new column that assigns a dollar value to the row based on the number in the first column. The bands I have created are as follows: Numbers 30 and greater= $42,000 Numbers between 21 and 30 = $26,000 Numbers 20 and less = $10,000 I have tried IF statements without luck, any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign a number to a name | Excel Worksheet Functions | |||
| How do I enter a negative dollar amount? | Excel Discussion (Misc queries) | |||
| a formula to find total compound amount after given number of yea. | Excel Worksheet Functions | |||
| How can I assign a number to a string? | Excel Discussion (Misc queries) | |||
| assign auto number and auto date | Excel Discussion (Misc queries) | |||
Threaded Mode
