Joined

·
2,676 Posts

Column A--List Price

Column B--35% Discount

Column C--My Cost

What do i need in column B to automatically calculate the list price minus discount into column C???

Thanks

1 - 13 of 13 Posts

Joined

·
2,676 Posts

Column A--List Price

Column B--35% Discount

Column C--My Cost

What do i need in column B to automatically calculate the list price minus discount into column C???

Thanks

Joined

·
1,862 Posts

In COlumn C the formula is =A1-B1 or =A1-(A1*.35)

Joined

·
4,664 Posts

What are you gettin a 35% discount on, i want one!!

Joined

·
2,676 Posts

Phone Equipment...you need someWhat are you gettin a 35% discount on, i want one!!

Joined

·
9,448 Posts

Joined

·
3,242 Posts

Joined

·
2,676 Posts

Yes...thanks for the help.Is this what you're looking for?

Enter a formula into whatever cell you need. Then to copy the formula to the next cell below, move your mouse pointer to the bottom right corner of the cell that you just entered a formula into. The mouse pointer will change from a white plus sign to a black plus sign. This is the fill handle.

Click and hold on that corner (with mouse as a black plus sign) and drag (any direction). Excel will copy the formula you entered in the source cell to all the destination cells, changing numbers or letters depending on what direction you drag.

Example: If you type into cell C3, =A3 + B3 and drag down, on row 4 (in cell C4) the formula will automatically be changed to =A4 + B4.

Joined

·
5,635 Posts

Joined

·
6,256 Posts

Enter a formula into whatever cell you need. Then to copy the formula to the next cell below, move your mouse pointer to the bottom right corner of the cell that you just entered a formula into. The mouse pointer will change from a white plus sign to a black plus sign. This is the fill handle.

Click and hold on that corner (with mouse as a black plus sign) and drag (any direction). Excel will copy the formula you entered in the source cell to all the destination cells, changing numbers or letters depending on what direction you drag.

Example: If you type into cell C3, =A3 + B3 and drag down, on row 4 (in cell C4) the formula will automatically be changed to =A4 + B4.

Type 1 into a cell and fill, all will say 1.

Type 1 into a cell, and 2 into the adjacent cell, then fill and cells will say: 1, 2, 3...

Type 1 into a cell and 5 into and adjacent cell,

then fill and cells will say: 1, 5, 9, 13...

Type January into a cell and fill. will do months

Type Sunday, Type times, dates... all will fill.

Now, if you want a cell in a formula to not change when you fill; put a dollar mark in front of the cell reference.

Example: = A2 * $B$2, filled downward, next cell will say = A3 * $B$2 - two won't change because of the dollar mark. Filled sideways, letter won't change because of the dollar mark.

1 - 13 of 13 Posts

Join the discussion

2 Cool Fishing Forum

A forum community dedicated to anglers in the Texas area. Come join the discussion about fishing guides, bait, safety, gear, tackle, tips, reviews, accessories, classifieds, and more!

Full Forum Listing
Recommended Communities

Join now to ask and comment!