50% formula

Originally Posted by wally

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 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