Breaking down an excel formula

[JeremyAGoodson]

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

 

[vezerid]

Apparently the previous user wanted to calculate a percentage. Note
that some numbers are in a scale of 0-100 whereas others are in the
scale of 0-100%, i.e. 0-1.

The result seems to be a weighted average where column D participates
by 50% and columns C and E participate by 25% respectively. C and E
are in the latter scale hence they are multiplied by 100, to bring
them to 0-100 and then by 0.25.

Does this help?
Kostis Vezerides

 

[JeremyAGoodson]

Apparently the previous user wanted to calculate a percentage. Note
that some numbers are in a scale of 0-100 whereas others are in the
scale of 0-100%, i.e. 0-1.

The result seems to be a weighted average where column D participates
by 50% and columns C and E participate by 25% respectively. C and E
are in the latter scale hence they are multiplied by 100, to bring
them to 0-100 and then by 0.25.

Does this help?
Kostis Vezerides







- Show quoted text -

Yes, This helps tremendously! Thank you so much! Is there a way you
can show me how to do this formula on a calulator? For example:


100-.5/100 - This is just an example. Can you show me something like
this please?

Thanks!

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[JeremyAGoodson]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk










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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk