Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling Cells with one Static Cell
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Value of one cell a certain number of cells away from another cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |