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