Match/Lookup Statements
 

I would like to create an equation that returns mult. results based on one
cell.

If "C1" = 4.0 - 3.5, =4.0
If "C1" = 3.49 - 2.5 = 3.0
If "C1" = 2.49 - 1.10 = 2.0
If "C1" = 1.09 - 0 = 0.0

I believe that I need a Lookup of Match Statment, but I'm not sure how to
write one. Thanks for the help!

=VLOOKUP(C1,{0,0;1.1,2;2.5,3;3.5,4},2)*(AND(C1=0, C1<=4))
the *AND part of the formula will ensure that the values are within 0 and 4

"Brian in FT W." wrote in message
...
I would like to create an equation that returns mult. results based on one
cell.

If "C1" = 4.0 - 3.5, =4.0
If "C1" = 3.49 - 2.5 = 3.0
If "C1" = 2.49 - 1.10 = 2.0
If "C1" = 1.09 - 0 = 0.0

I believe that I need a Lookup of Match Statment, but I'm not sure how to
write one. Thanks for the help!

Hi

=(C11.09)*(ROUND(C1,0)+(C1<1.5))
formatted as number with 1 decimal

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Brian in FT W." wrote in message
...
I would like to create an equation that returns mult. results based on one
cell.

If "C1" = 4.0 - 3.5, =4.0
If "C1" = 3.49 - 2.5 = 3.0
If "C1" = 2.49 - 1.10 = 2.0
If "C1" = 1.09 - 0 = 0.0

I believe that I need a Lookup of Match Statment, but I'm not sure how to
write one. Thanks for the help!

Thanks everyone, that worked!

"Arvi Laanemets" wrote:

Hi

=(C11.09)*(ROUND(C1,0)+(C1<1.5))
formatted as number with 1 decimal

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Brian in FT W." wrote in message
...
I would like to create an equation that returns mult. results based on one
cell.

If "C1" = 4.0 - 3.5, =4.0
If "C1" = 3.49 - 2.5 = 3.0
If "C1" = 2.49 - 1.10 = 2.0
If "C1" = 1.09 - 0 = 0.0

I believe that I need a Lookup of Match Statment, but I'm not sure how to
write one. Thanks for the help!