sum based on value in a range

S

Siegfried

Joined
Jun 27, 2014
Messages
1
Reaction score
0
Dear excel experts,

I would like to request your help & expertise with the following excel problem I'm facing.

I have below range of maximum values:
B2 : 100
B3 : 1000
B4: 2000
B5: 10000
B6: 30000

In cell B12 I have a value, let's say 1566.
With this value I want to make a sum based on the nearest maximum value, in this example B4: 2000. Sum 2000 - 1566 = 434.
Hence, excel has to find the nearest corresponding maximum in the range for the value in B12 and then make the sum with that value.

How can I do this.

Thanks for your help.

Best regards,

Siegfried
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Use TODAY() function as the criteria in a SUMIF formula 1
Drop down list control value in vba 2
sum a cell value to a range 4
Return Range Based on Cell Value 4
group values based on a range using IF function 1
Need Help with a VBA subroutine 0
How do I set focus (and select text) on a text box on a modeless userform? 0

Top