Formula

  • Thread starter Thread starter jpizzle
  • Start date Start date
J

jpizzle

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
 
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
 
Well, to start with, throw away the SUM function unless you are going to use
it. [SUM will add a number of inputs, but you haven't given it a number of
inputs.]
It sounds as it what you want is =ROUNDDOWN((F4+H4)/2,-1)+8
 
Thank you works great
--
jpizzle


David Biddulph said:
Well, to start with, throw away the SUM function unless you are going to use
it. [SUM will add a number of inputs, but you haven't given it a number of
inputs.]
It sounds as it what you want is =ROUNDDOWN((F4+H4)/2,-1)+8
--
David Biddulph

jpizzle said:
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
Click to expand...
Click to expand...
 
Thank you works great
--
jpizzle


Pete_UK said:
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
Click to expand...
 
Back
Top