Breaking down an excel formula
 

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

Breaking down an excel formula
 

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

On Oct 11, 8:12 pm, wrote:
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

Breaking down an excel formula
 

On Oct 11, 1:40 pm, vezerid wrote:
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

On Oct 11, 8:12 pm, wrote:



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 -

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!

Breaking down an excel formula
 

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

Breaking down an excel formula
 

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!

Breaking down an excel formula
 

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!