Relative & Absoulate both Vertical & Horizontal

[owainjones]

See attachment for what I have done so far, and you can view the XLS
file here at: www.owainjones.co.uk/Swan Hotel.xls

"Enter a formula into each respective cell to calculate the total hire
charges for each room for each week. You should include the data
already held in row 3 as part of your formulae, using absolute and
relative cell references as appropriate to ensure your formulae can be
replicated across and down easily."

I think I have done the down bit, but I can't figure out how to do the
same for the horizonal bit using the same formula.

Any help/pointers would help a lot! - Thanks


+-------------------------------------------------------------------+
|Filename: swanhotel01.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4636 |
+-------------------------------------------------------------------+

 

[Carim]

Hi,

In cell L4, you should be typing
=B4*B$3

Then you can copy this formula in your whole table down to L16 an
cross to column U ...

HTH
Cheers
Cari