rolito
New Member
- Joined
- Jun 14, 2007
- Messages
- 14
I have a formula in Excel 2007 table like this:
=[Quantity]*[Price-Jan-08]
I would like to copy that formula to the right with quantity absolute fixed and Price been relative.
In Excel 2003 I used the "$", but in this new Excel 2007 table formulas I don´t know how to copy this formula to the right and let it change to:
=[Quantity]*[Price-Feb-08]
=[Quantity]*[Price-Mar-08]
.....
Any suggestion on how to fix the [Quantity] when copying to the right?
Thanks a lot for your help !
=[Quantity]*[Price-Jan-08]
I would like to copy that formula to the right with quantity absolute fixed and Price been relative.
In Excel 2003 I used the "$", but in this new Excel 2007 table formulas I don´t know how to copy this formula to the right and let it change to:
=[Quantity]*[Price-Feb-08]
=[Quantity]*[Price-Mar-08]
.....
Any suggestion on how to fix the [Quantity] when copying to the right?
Thanks a lot for your help !