Software

Ask something
Discussion Locked

Excel Formula

0 helpful
3 replies

by dwightp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Good day:

Looking for a simple Excel formular to take 15% off totals in Column D and put the results in Column E.

Thanks everyone for your help!

Dwight

3 replies

by softcorp.us

Hello...

The formula is:

=Dn*.85

where "n" is the row number.

Steps:

1. In cell E1, type

=D1*.85

2. Propagate the formula in E1 to as many rows as necessary (E2, E3, ...).

The quick way to do this is to select cell E1. Then, click and drag the little black box in the bottom right corner of cell E1 across the cells in column E down the sheet as far as you need. This will automatically set the row number correctly.

Did this work for you?

-----Steve Jackson

CEO/CSA
Software Corporation (Softcorp)
http://www.softcorp.us/probono
Advanced pro bono tools and utilities free for personal use

by dwightp

Thanks Steve! Greatly appreciate this help! Take good care and enjoy the rest of the day!

Mindfully,

Dwight

This discussion is closed to new replies.