ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   is there a solution to get the result in V? (https://www.excelbanter.com/excel-worksheet-functions/186756-there-solution-get-result-v.html)

Marc[_3_]

is there a solution to get the result in V?
 
X= the max that can be given
S= what clients already have
T= what can be given to get the max (X)
U= what is needed to get to the max
V= is what is possile to give from what is over in T
W= what is left from that wat kan be given (T)


S T U V W X
40 123 35 35 88 75
20 88 55 55 33 75
10 33 65 33 0 75
11 0 64 0 0 75
10 0 65 0 0 75
45 0 30 0 0 75
30 0 45 0 0 75
2 0 73 0 0 75
15 0 60 0 0 75
6 0 69 0 0 75

Thanks in advance.

Bob Bridges

is there a solution to get the result in V?
 
From what I can see, V is always =MIN(T<row:U<row). That would be the
solution, no?

No; because that's too easy. You must have been asking a different
question, but I can't figure out what it is. You want to get the contents of
column V? No, that's too easy too. Once you have column V, what do you want
to do with it?

--- "Marc" wrote:
X= the max that can be given
S= what clients already have
T= what can be given to get the max (X)
U= what is needed to get to the max
V= is what is possile to give from what is over in T
W= what is left from that wat kan be given (T)

S T U V W X
40 123 35 35 88 75
20 88 55 55 33 75
10 33 65 33 0 75
11 0 64 0 0 75
10 0 65 0 0 75
45 0 30 0 0 75
30 0 45 0 0 75
2 0 73 0 0 75
15 0 60 0 0 75
6 0 69 0 0 75



All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com