| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| I need to add and subtract time cells. ie. 13:45 minus 13:58 | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
