Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
50% formula
I have winxp 2003.
I have a sheet named data which has a list of names that looks like this; in cell a1 #1 Jackson - #2 Johnson in cell a2 #3 Smith - #4 Jones, etc, with different names for six more cell counting down. In addition each name listed has their own sheet assigned to them, sheet 1 is Jackson, sheet 2 is Johnson, sheet 3 is Smith, etc. In cell r3 of each sheet s a two digit number, i.e. sheet 1, r3 84, sheet 2, r3 54, etc. I would like to take the number on sheet 1, cell r3 compared to the number on sheet 2, cell r3, then take 50% of the difference of the two numbers and give to the person with the lowest number. I don't mean to add it to the existing number but just show the difference in a separate cell along side the name of the person on sheet named data. Therefore, if sheet1, r3 has 84 and sheet 2 r3 has 34, 50% of the difference of 30 is 15 and 15 is given to #2 in a separate cell along side the name of Johnson. All numbers are to be rounded down to no fractions. If both numbers are the same in cell r3 a zero would show in cell bx. The final product would look like this; cell a1 cell b1 Jackson - Johnson Johnson 15 cell a2 cell b2 Smith - Jones Smith 5 cell a3 cell b3 Callis - Dallas 0 Etc, for the next 5 cells containing the rest of the list. I hope you folks can help, thank you in advance. Wally |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
50% formula
wally Wrote: I would like to take the number on sheet 1, cell r3 compared to the number on sheet 2, cell r3, then take 50% of the difference of the two numbers and give to the person with the lowest number. Therefore, if sheet1, r3 has 84 and sheet 2 r3 has 34, 50% of the difference of 30 is 15 and 15 is given to #2 in a separate cell along side the name of Johnson. Wally Where did the 30 come from? -- iturnrocks ------------------------------------------------------------------------ iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246 View this thread: http://www.excelforum.com/showthread...hreadid=570715 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
50% formula
iturnrocks wrote: wally Wrote: I would like to take the number on sheet 1, cell r3 compared to the number on sheet 2, cell r3, then take 50% of the difference of the two numbers and give to the person with the lowest number. Therefore, if sheet1, r3 has 84 and sheet 2 r3 has 34, 50% of the difference of 30 is 15 and 15 is given to #2 in a separate cell along side the name of Johnson. Wally Where did the 30 come from? Sorry, I made a mistake. The 30 should be 50 that is, 84-34=50. So 50% of 50 is 25 and 25 goes to #2. Does that clear it up?, Thanks -- iturnrocks ------------------------------------------------------------------------ iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246 View this thread: http://www.excelforum.com/showthread...hreadid=570715 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |