View Single Post
  #1   Report Post  
chalky
 
Posts: n/a
Default 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