Looku values

A

artman

I have two columns, one has money values and the other %.
per Ex:
column A column B
0€ 0%
135,90 € 2%
155.20€ 5%

What i want to do is, if a have a value, per ex: 135,89€, the expression
should return me 2%, if I have 135.90€ or higher it should return me 5%.

If anyone could help, I would be very greatfull.

Tank you, artman.
 
D

David Billigmeier

First, sort your column A values in descending order, and use the following
formula. You just need to change the row numbers to fit your data (I assumed
C1 is where you want to place your values to lookup):

=INDEX(B1:B3,MATCH(C1,A1:A3,-1))
 
B

Bob Phillips

=IF(A1<135.9,2%,5%)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
A

Ashish Mathur

Hi,

I have worked on a similar problem before. Hope this helps you

This is entered in range B2:C8

Income slab Rate

- 0%
50,000.00 10%
150,000.00 20%
320,000.00 30%
600,000.00 40%

In cell C10, enter the amount and in C12, enter the following array formula
(Ctrl+Shidt+Enter)

SUM(IF($C$10<B4:B8,0,IF(B5:B9-B4:B8>$C$10,$C$10-B4:B8,IF(B5:B9-B4:B8>0,IF(B5:B9-B4:B8>$C$10-B4:B8,$C$10-B4:B8,B5:B9-B4:B8),$C$10-B4:B8)))*(C4:C8))

You may just have to adjust the ranges.

Please feel free to contavt me if you need any more help

Regards,

Ashish Mathur
[email protected]
 
Top