Thread: Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jpizzle jpizzle is offline
external usenet poster
 
Posts: 3
Default Formula

Thank you works great
--
jpizzle


"David Biddulph" wrote:

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