Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=+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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using drop-down lists 4
Greater Than but Less than 5
How to make an exponential series? 2
How can I get Microsoft excel to calculate increasing number again 2
formula for adjusting price 1
Index/Match or Vlookup 2
Sum and Percentage Question... 2
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1

Back
Top