Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miss Texas
 
Posts: n/a
Default How do I create a formula by percentage within a formula?

I need help. I created a salary expense worksheet and i already have a
formula created in one of the cells. the problem is asking to create a
formula to reduce 25% of anything by multiplying the --- by 75%.

How can I do that when I already have a formula in that row/column?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default How do I create a formula by percentage within a formula?

Use another cell that points to the cell with the formula and do the
calculation or copy and paste special the values in the formula column, then
put 0.75 in an empty cell, copy it, select the values and do editpaste
special and select multiply. i would definitely use the first alternative.

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Miss Texas" <Miss wrote in message
...
I need help. I created a salary expense worksheet and i already have a
formula created in one of the cells. the problem is asking to create a
formula to reduce 25% of anything by multiplying the --- by 75%.

How can I do that when I already have a formula in that row/column?


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
help create a formula using the IF command with AND [email protected] Excel Discussion (Misc queries) 2 January 16th 06 06:29 PM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
How do I create a 26 'tier' IF formula? callum Excel Discussion (Misc queries) 5 October 23rd 05 04:48 PM
How to create specific formula STS Excel Worksheet Functions 4 May 2nd 05 01:44 AM
How do I create a formula that would allow me to subtract from a d Justlearning New Users to Excel 5 January 27th 05 09:47 PM


All times are GMT +1. The time now is 06:06 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"