| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return value
Hi all,
I have a column of data: column A 0 20 30 40 60 70 90 under following criteria, i want to have column B return certain values: 0 to 30, return 10 40 to 60, return 20 70 to 100, return 30 Is there a formula that can help me to achieve this? Thank you -- ==================== ask and you shall be answered |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
return value
Perhaps A simple if
=if(a1=70,30,if(a1=40,20,if(a1=0,10,"")))) -- Don Guillett Microsoft MVP Excel SalesAid Software "Zhi Sheng" wrote in message ... Hi all, I have a column of data: column A 0 20 30 40 60 70 90 under following criteria, i want to have column B return certain values: 0 to 30, return 10 40 to 60, return 20 70 to 100, return 30 Is there a formula that can help me to achieve this? Thank you -- ==================== ask and you shall be answered |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
return value
Try this formula...
=IF(A1<=30,10,IF(A1<=60,20,30)) Rick "Zhi Sheng" wrote in message ... Hi all, I have a column of data: column A 0 20 30 40 60 70 90 under following criteria, i want to have column B return certain values: 0 to 30, return 10 40 to 60, return 20 70 to 100, return 30 Is there a formula that can help me to achieve this? Thank you -- ==================== ask and you shall be answered |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX then return value? | Excel Discussion (Misc queries) | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Return Value | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
Linear Mode
