Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 108
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel result return wrong calcuation result garyww Excel Worksheet Functions 0 August 14th 06 05:02 AM
excel result return wrong calcuation result garyww Excel Worksheet Functions 0 August 14th 06 05:02 AM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM
Importing result from Access query to Excel but the result only c. Edwin Excel Discussion (Misc queries) 0 March 16th 06 01:36 AM
vlookup based on random result returns incorrect result rickat Excel Worksheet Functions 1 December 6th 05 01:16 PM


All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"