Combine Formulas

[shawnmoody]

How do I combine these 2 formulas in the same cell?

in cell H6 I have this formula
=(A14*E14+A15*E15+A16*E16+A17*E17+A18*E18+A19*E19+A20*E20+A21*E21+A22*E22+A23*E23+A24*E24+A25*E25+A26*E26+A27*E27+A28*E28+A29*E29)/12

In cell H7 I have this formula: =CEILING(H6+1/4,0.25)

I want the result of both formulas to be in Cell H6.

I want my final result in H6 to roundup to .25 and then add anothe
.25

I hope this makes sense, because I am terrible at using Excel an
formulas.

Thanks

 

[Peo Sjoblom]

You can shorten that considerably

your first formula is equal to

=SUMPRODUCT(A14:A29,E14:E29)/12

so in H6 use

=CEILING(SUMPRODUCT(A14:A29,E14:E29)/12+1/4,0.25)

 

[J.E. McGimpsey]

one way:

=CEILING(SUMPRODUCT(A14:A29,E14:E29) + 0.25, 0.25)

 

[J.E. McGimpsey]

Missed the /12:

=CEILING(SUMPRODUCT(A14:A29,E14:E29)/12 + 0.25, 0.25)

 

[shawnmoody]

Thanks! Both of those formulas worked.

 

[orange]

Mr. Moody, You were close. You just need to change your formula so
that it looks like this: =CEILING(H6,0.25)+0.25

You were trying to add the 1/4 or .25 before the ceiling function had
a chance to do its thing. Now what's happening with the formula above
is that the function is looking at your value in H6 and determining if
it needs to rounded up. THEN, it adds the .25

Have a great day!!