Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
=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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF statements | Excel Worksheet Functions | |||
4 different if statements, not working | Excel Worksheet Functions | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |