ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula Question (https://www.excelbanter.com/excel-worksheet-functions/55029-formula-question.html)

Marcus Feldmore

Formula Question
 
=+Cost!D31/Price!$O$2 this formula is being used to link two sheets of
pricing together. I need to make an adjustment to this formula to times it by
1.05. How can I add this to the formula to adjust everything with
multiplying by 1.05. Thanks in advance for your help

chalky

Formula Question
 

Just pop brackets around the calculation you have and then multiple by
1.05. ie:

=(Cost!D31/Price!$O$2)*1.05

If the 1.05 is ever going to change link this to a cell to give you the
flexibility to change it, ie:

=(Cost!D31/Price!$O$2)*A1


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=484298



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

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