Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question | Excel Discussion (Misc queries) | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |