LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
vsoler
 
Posts: n/a
Default Filling the glasses of beer

A difficult one for me!!!

A B C D
1 7 3 5 4
2 4 1 3 2
3 ? ? ? ?

I have 4 glasses of beer filled with, say 7, 3, 5 and 4 cubic
centimeters (row 1)
I RANK them from more empty to less empty (row 2, not my question)

Now, I have 20 cubic centimeters of beer to fill my glasses, starting
from the more empty and finishing in the less empty.

If the capacity of a glass is 10 cubic centimeters, what's the formula
for row 3 which will give me the beer in each glass after I pour the
beer?

Please, I'm looking for a formula that does not use any intermediate
calculations in other cells.

Want to share the beer with me?

 
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
filling up data in blankrows! via135 Excel Worksheet Functions 4 January 20th 06 05:24 AM
help! gipsassignment Excel Worksheet Functions 1 October 2nd 05 11:57 AM
filling information from one cell and filling another. Dianne Excel Worksheet Functions 1 August 15th 05 08:14 PM
Printing a workbook one row at a time filling in a form with the d LostinData New Users to Excel 1 May 6th 05 08:16 PM
In a column with no data, only color filling, how can I filter fo. Edmond Excel Discussion (Misc queries) 1 April 5th 05 05:17 PM


All times are GMT +1. The time now is 08:40 AM.

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

About Us

"It's about Microsoft Excel"