| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I return a calculation based on several ranges?
How (or can) I enter a formula that would do the following:
if G6 is C46 and <E46 then multiply by G46, but if G6 is C48 and <E48 then multiply by G48. I have five sets of ranges to include and five different amounts to multiply by based on the number in G6. Example, if G6 is between 800 and 2400 then multiply it by .254, if it's between 2401 and 5000 then multiply it by .234 and so on. Thanks! -- Nanci |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to return a value based on a whether a number is within a ra. | Excel Worksheet Functions | |||
| I want to return "0" based on another cell | Excel Worksheet Functions | |||
| Counting an Array based on a calculation | Excel Discussion (Misc queries) | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Threaded Mode
