View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

=ROUNDDOWN((((B4+D4+J4+M4+P4+Q4)*3)-72)*0.8,0)

Don't forget that Excel has its own help facility, which will tell you a lot
about the functions you're trying to use, and what parameters each function
needs as inputs.
--
David Biddulph

"George A. Yorks" .(donotspam) wrote in message
...
=rounddown((((B4+D4+J4+M4+P4+Q4)*3)-72)*.8). I've entered this formula and
receive an error message "you've entered too few arguments for this
functiion


"George A. Yorks" wrote:

Thank you much for all the help
--
George


"Dave F" wrote:

=ROUNDDOWN((((A1+B1+C1+D1)*3)-72)*.8)

Dave
--
Brevity is the soul of wit.


"George A. Yorks" wrote:

Thanks for this information one added step. I would like to round
this
result down. ie: 14.4 to 14.
--
George


"Dave F" wrote:

=(((A1+B1+C1+D1)*3)-72)*.8

Adjust cell references to suit your needs.
--
Brevity is the soul of wit.


"George A. Yorks" wrote:

I am trying to create a formula. I want to add the values of
cells ab-ae
multiply by 3 subtract 72 (can do all of this) want to multiply
the result by
80% this I have not been able t do. any help appreciated
--
George