|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com