Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80%

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80%

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80%

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

=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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

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

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

=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

  #8   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

=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

  #9   Report Post  
Posted to microsoft.public.excel.misc
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



  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

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



  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default add value of 4 cells, multiply by 3 subtract 72 multiply by 80

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
I need to add and subtract time cells. ie. 13:45 minus 13:58 Mschertz Excel Discussion (Misc queries) 1 October 21st 05 06:30 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM


All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"