You're welcome - thanks for feeding back.

Pete

On Mar 12, 11:00*pm, jpizzle
wrote:
Thank you works great
--
jpizzle



"Pete_UK" wrote:
First of all, you don't need the SUM in the first formula, but I assume that
this formula would be in A1 for your second formula. So, you can combine
them like this:

=ROUNDDOWN((F4+H4)/2,-1)+8

Hope this helps.

Pete

"jpizzle" wrote in message
...
This is my current simple formula for a column. =SUM(F4+H4)/2 However when
I
get the result I want to now perform this operation
=Sum(ROUNDDOWN(A1,-1)+8).
How can I incorporate both formulas into one operation for one column?
Thank you
--
jpizzle- Hide quoted text -

- Show quoted text -