| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
return a value based on a range
I want to return a value (a number) based on a number in anotehr cell that is
within a range of numbers using the IF function. For example: A2=$75 if B2=5, A2=$100 if B2=10, A2=$150 if B2=15. Can someone please give me the correct syntax, I am really lost! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum a range which includes the "#N/A" VLOOKUP return valu | Excel Worksheet Functions | |||
| I want to return a value based on the status of a check box. If . | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
| Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
Threaded Mode
