Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

is there a solution to get the result in V?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marc - 08 May 2008 21:40 GMT
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 - 09 May 2008 01:16 GMT
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?

> X= the max that can be given
> S= what clients already have
[quoted text clipped - 14 lines]
> 15       0   60     0     0   75
> 6         0   69     0     0   75
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.