Sorry, I forgot to include the number of digits to which you want to round
the value.

Dave
--
Brevity is the soul of wit.


"George A. Yorks" wrote:

Once again thanks for the help
--
George


"CLR" wrote:

=rounddown((((B4+D4+J4+M4+P4+Q4)*3)-72)*.8,0)

Vaya con Dios,
Chuck, CABGx3



"George A. Yorks" wrote:

=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


"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