ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   adding function to an existing formula (https://www.excelbanter.com/excel-worksheet-functions/197849-adding-function-existing-formula.html)

chickenita

adding function to an existing formula
 
I am an excel virgin, so please bear with me! I have an existing formula, I
would like to divide the subtotal by 2, how would I do that?
--
anita

Mike H

adding function to an existing formula
 
=yourformula/2

"chickenita" wrote:

I am an excel virgin, so please bear with me! I have an existing formula, I
would like to divide the subtotal by 2, how would I do that?
--
anita


Glenn

adding function to an existing formula
 
chickenita wrote:
I am an excel virgin, so please bear with me! I have an existing formula, I
would like to divide the subtotal by 2, how would I do that?



If you would post your "existing formula", an exact solution could be provided.
Otherwise, look at "divide numbers" in the help file.

=(your existing formula)/2

Note that the parenthesis may be necessary to force Excel to calculate "your
existing formula" first, than divide by 2.


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com