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
|