| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If/Or Formula - Which formula do I use?
I'm trying to set up a formula that pulls a dollar amount from a separate
worksheet. If the cell in my worksheet contains the number 1, I want it to pull a certain dollar amount. If the same cell contains the number 3, I want it to pull a different dollar amount. If the same cell contains the number 6, I want it to pull a different dollar amount. If the same cell contains the number 11, I want it to pull a different dollar amounts. All of these dollar amounts are listed in a worksheet in the same document. Can this be done? If so, what type of formula should I use? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
