Combine Formulas

  • Thread starter Thread starter shawnmoody
  • Start date Start date
S

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
 
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)
 
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!!
 
Back
Top