Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |