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

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

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