Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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.
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
adding a round function to an existing formula Deb Paiement Excel Worksheet Functions 2 July 10th 08 09:28 PM
Adding to an existing formula JPS Excel Worksheet Functions 2 April 17th 08 04:04 PM
Formula or Function to Set Many Existing Numbers in Same Format? V. Hatherley Excel Discussion (Misc queries) 4 August 17th 06 12:13 AM
adding formula to existing database Country Boy Excel Worksheet Functions 3 September 5th 05 03:50 PM
What is the formula for adding a number of days to an existing dat Ivan Excel Worksheet Functions 1 May 4th 05 03:00 AM


All times are GMT +1. The time now is 06:52 PM.

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

About Us

"It's about Microsoft Excel"