General discussion

Locked

Excel Formula

By dwightp ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by softcorp.us In reply to Excel Formula

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

Collapse -

by dwightp In reply to

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

Mindfully,

Dwight

Collapse -

by dwightp In reply to Excel Formula

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums