Formula symbol question

[THTABE]

Hello All,

I have a fairly simple question I think. One of my customers has supplied me with a work sheet that brakes down our Delivery Fee and adds it to the products I think in a proportional manner. Being a novice at best when it comes to Excel I am trying to figure out how he is doing this. Can someone tell me what the following formula does in simple terms? =(H16*I$21)/100 specifically what does the “$” do? I could not find the forum rules on attaching excel files I think they are out there some where thought.

Thanks again,

Easly Stumped

[NBVC]

The formula multiplies the value in cell H16 by the value in cell I21 and then divides by 100.

The $ makes the Row number 21 absolute (ie. it "freezes" the number in the formula) so that when the formula is copied down it always refers I21 and so each value in column H is always multiplied by value in cell I21.

If the formula is copied across, however, the I is not "frozen" and so would change to J21, K21, L21, etc....

[THTABE]

I just wanted to say thank you. I have always been able to get quick and accurate information in this forum.