| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula setup
Good morning. I am trying to figure out a formula that will automatically
show me which range the DAPC number falls into. For example, DAPC 0% = <$16.98 $13.89 50% = $16.99 - 19.98 100% = $19.99 - 22.98 150% = $22.99 - 25.98 200% = $25.99 The formulat would need to give me the result of 0%, 50%, 100%, 150% or 200%. Any suggestions would be appreciated! Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula setup
=LOOKUP(DAPC,{0,16.99,19.99,22.99,26},{0,0.5,1,1.5 ,2})
and format as a percentage -- __________________________________ HTH Bob "Liz" wrote in message ... Good morning. I am trying to figure out a formula that will automatically show me which range the DAPC number falls into. For example, DAPC 0% = <$16.98 $13.89 50% = $16.99 - 19.98 100% = $19.99 - 22.98 150% = $22.99 - 25.98 200% = $25.99 The formulat would need to give me the result of 0%, 50%, 100%, 150% or 200%. Any suggestions would be appreciated! Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula setup
Hi
=if(A1<=16.98,"0%",if(A1<=19.98,"50%",if(a1<=22.98 ,"100%",if(a1<=25.98,"150%","250%") "Liz" wrote: Good morning. I am trying to figure out a formula that will automatically show me which range the DAPC number falls into. For example, DAPC 0% = <$16.98 $13.89 50% = $16.99 - 19.98 100% = $19.99 - 22.98 150% = $22.99 - 25.98 200% = $25.99 The formulat would need to give me the result of 0%, 50%, 100%, 150% or 200%. Any suggestions would be appreciated! Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula setup for number combinations | Excel Worksheet Functions | |||
| formula setup | Excel Worksheet Functions | |||
| help with Hyperlink formula setup | Excel Discussion (Misc queries) | |||
| Formula setup / OFFSET problem | Excel Discussion (Misc queries) | |||
| how to setup formula? | Excel Worksheet Functions | |||
Linear Mode
