ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I create a formula by percentage within a formula? (https://www.excelbanter.com/excel-worksheet-functions/79771-how-do-i-create-formula-percentage-within-formula.html)

Miss Texas

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?

Peo Sjoblom

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?




All times are GMT +1. The time now is 10:26 PM.

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