add value of 4 cells, multiply by 3 subtract 72 multiply by 80%

's Computer Specifications

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

's Computer Specifications

=(((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

's Computer Specifications

Hi George.......

If by "multiply the result by 80%" you mean to INCREASE it by 80%, then just
multiply your result by 1.8

Vaya con Dios,
Chuck, CABGx3

"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

's Computer Specifications

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

's Computer Specifications

=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

's Computer Specifications

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

's Computer Specifications

=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

's Computer Specifications

=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

's Computer Specifications

=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" <(E-Mail Removed).(donotspam)> wrote in message
news:43CEE61A-7A42-4CC5-A868-(E-Mail Removed)...
> =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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Sum equivalent for Subtract / Multiply / Divide	ragde	Microsoft Excel Misc	2	15th Jul 2009 01:12 PM
Subtract and multiply as a code ????????	Tdp	Microsoft Excel Misc	6	10th Nov 2008 03:35 PM
Multiply Every 2 Cells	=?Utf-8?B?RGF2aWQgTSBD?=	Microsoft Excel Programming	6	31st Jul 2006 08:35 AM
HOW DO YOu MULTIPLY AND SUBTRACT IN ACCESS?	=?Utf-8?B?QW5nZTI=?=	Microsoft Access	3	14th Mar 2006 04:48 PM
How do I multiply cells?	=?Utf-8?B?Z2VuZV9waXRtYW4=?=	Microsoft Excel Worksheet Functions	4	9th Apr 2004 10:56 PM