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!
|