LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default SINGLE NUMBER BREAK OUT INTO 5 COLUMNS

I have to translate actual score of 7/10 into 5 cells where the maximum in
each cell can only be 2. So the end result for this 7=2,2,2,1,0=7

In A1 I have a total test score of 10
In A2 I have the actual score = 7

SO this means that I scored 7 out of 10.

Now I am looking for a formula that breaks out the score of 7 into 5 cells
b2:f2 with the maximum of 2 being inserted into each cell. The end result
for 7 would be 7=2,2,2,1,0 or the end result for 3 would be 3=2,1,0,0,0.,etc,
etc.

Can anyone help please?
 
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
break data into columns Totti Excel Discussion (Misc queries) 4 November 16th 08 12:33 PM
move multiple columns into single set of columns mrg9999 Excel Discussion (Misc queries) 1 September 25th 07 05:08 AM
How to break out data combined in a single cell juliejg1 Excel Worksheet Functions 6 July 20th 07 04:45 PM
Break-up for a single row Salman Excel Worksheet Functions 0 February 26th 07 07:09 AM
EXCEL 2000 SINGLE COLUMN OF NUMBERS BREAK INTO MANY COLUMNS Emily Excel Worksheet Functions 4 September 21st 06 06:12 PM


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

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"