Solved Formula for Greater and Less than

May 6, 2013 at 10:09:03
Specs: Windows 7
GROSS SERVICE SALES=CREDIT

$0 - $12,000 =$50.00
$12,001 - $16,000 =$65.00
$16,001 - $20,000 =$80.00
$20,001 - $24,000 =$85.00
$24,001 - $28,000 =$110.00
$28,001 - $32,000 =$125.00
$32,001 + = $140.00

This is on sheet one, and the sales total are on sheet 2.
If I put in a sales total, I would like the credit to automatically calculate according to what the gross service sales is. Any ideas on how to do that?


See More: Formula for Greater and Less than

Report •

#1
May 6, 2013 at 20:57:47
✔ Best Answer
Use VLOOKUP with a range_lookup argument of TRUE (1)

With my example below, D1 should display 65


     A       B      C                   D
1      0    50    14045      =VLOOKUP(C1,$A$1:$B$7,2,1)
2  12001    65
3  16001    80
4  20001    85
5  24001   110
6  28001   125
7  32001   140

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question