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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks for this information one added step. I would like to round this
result down. ie: 14.4 to 14.
 
=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
 
=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.
 
Back
Top