wrote in message
ups.com...
81.00+(99.8%+100%)*25, will this give me the answer to G (90.45)?

Also

80.33+(99.7%+96%)*25. will this equal G (89.08)?

No, you forgot to divide the 81 by 2.

If entering it into a calculator it can be entered as:

81 / 2 + ((0.998+1) * 25)

or (0.998 + 1 ) * 25 + (81 / 2)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


wrote in message
ups.com...
On Oct 11, 2:03 pm, "Sandy Mann" wrote:
don't know what the previous person was trying to do because he/she was
adding a quarter of the percentages converted into numbers but:

=D24/2+(C24+E24)*25

and

=D4/2+(C4+E4)*25

return the same result when formatted as General.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

wrote in message

ups.com...



Hello,

May I have some help on understanding this excel formula. I am taking
over someone's job, and was curious to know how did this person come
up with this number based on this formula? I am looking for how they
found the answer to G which is 90-45 & 89.08 on the examples below.

C D E F G H

99.8% 81.00 100% 97% 90.45 90.454 =

(D24*0.5+E24*100*0.25+C24*100*0.25)

Here is another example:

C D E F G H
99.7% 80.33 96% 94% 89.08 89.085 =

=(D4*0.5+E4*100*0.25+C4*100*0.25)

Thanks,

Jeremy- Hide quoted text -

- Show quoted text -

Hello Sandy,

Thank you so much for your help. This is starting to come together
more and more. Based on the formula you provided: =D24/2+(C24+E24)*25
and =D4/2+(C4+E4)*25, I can just plug in these numbers and add them
on my calculator.

81.00+(99.8%+100%)*25, will this give me the answer to G (90.45)?

Also

80.33+(99.7%+96%)*25. will this equal G (89.08)?

Am I doing this correctly? Thanks so much again for everyone's help!