Combine Formulas

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
 
P

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)
 
O

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 6
Tricky Formulas 14
Tricky Formula 2
VBA code adds unwanted characters 2
formulas changing when sorting 1
Copy/Paste Help Please 0
trouble with formula 3
If condition for Blank Cell 4

Top