Forum Discussion
Solved
Excel formula help
Hi, I am building an excel spreadsheet and I need help putting together a formula that allows me to choose a $ amount based on a % range. let me explain: I need the formula to look at a cell, le...
AGuillot, that's like
=LOOKUP(E37,$D$46:$D$49,$G$46:$G$49)
if only you change D49 from 15% on 15.0000001% or so.
SergeiBaklanThat worked. awesome! Thankyou Sergei!!!!
AGuillot , you are welcome