miscofficestaff wrote:
Hi everyone,

Completely new here. Trying to create an order form for my office. I
have worked on this problem for two days now, trying everything.

I have about three hundred items with a selection of prices. And I have
a discount cell (b20), that changes depending on the customer. My
pricing is listed in the c column. So I am dragging the bottom right of
the box with my formula.

My problem is I need this formula to fill normally (c23, c24, c25, et
cetera) with my c column price, but still use the percentage in my b20
cell.

Does this make any sense? Am I explaining myself well? And can anyone
help?

Thanks so much for your time,
misc office staff


--
miscofficestaff
------------------------------------------------------------------------
miscofficestaff's Profile: http://www.excelforum.com/member.php...o&userid=36553
View this thread: http://www.excelforum.com/showthread...hreadid=563051

Hi,

I'm not quiet sure what you are looking for but it sounds like you
could benefit from looking into relative and absolute cell references
in the online help (F1).
Something like locking cell b20 with $ signs: $B$2 and then drag down
might be the solution.

Regards,
Bondi