# Need Help - Excel Question

**URL:** <https://boards.straightdope.com/t/need-help-excel-question/158754>\
**Category:** Factual Questions\
**Created:** [March 3, 2003, 3:05pm UTC](https://boards.straightdope.com/t/need-help-excel-question/158754 "2003-03-03T15:05:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mister\_me](https://avatars.discourse-cdn.com/v4/letter/m/cdc98d/32.png) [@mister\_me](https://boards.straightdope.com/u/mister_me)\
**Post date:** [March 3, 2003, 3:05pm UTC](https://boards.straightdope.com/t/need-help-excel-question/158754/1 "2003-03-03T15:05:17Z")

</div>

I’m hoping one of you Dopers can give me a helping hand, or rather a helping formula for an Excel spreadsheet I’m working on.  
What I have = a column (column A) of numbers (monetary value).

What I need = In a seperate column (column B), I need to list what 92.5 percent of the value of column A is.

Probably a simple question. Sorry, I don’t work with Excel much.

---

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [March 3, 2003, 3:10pm UTC](https://boards.straightdope.com/t/need-help-excel-question/158754/2 "2003-03-03T15:10:21Z")

</div>

in the first cell in column B that has a value next to it in column A, do this:

Type **=**  
Press the left arrow key  
type \ ***.925**  
Hit enter

That should do it for the first cell, now click the little square at the bottom right of the highlighted cell and drag it down to fill the whole column; it will copy the formula down into all of the cells you drag across.

---

<div class="post-metadata">

**Author:** ![xash](https://avatars.discourse-cdn.com/v4/letter/x/c6cbf5/32.png) [@xash](https://boards.straightdope.com/u/xash)\
**Post date:** [March 3, 2003, 3:35pm UTC](https://boards.straightdope.com/t/need-help-excel-question/158754/3 "2003-03-03T15:35:15Z")

</div>

In Column B corresponding to A1, type :

=(A1/100\*92.5)

Substitute A1 for A2,A3,A4 etc. for the other entries corresponding to column A. I don’t use Excel myself, but I’m sure there’s a way to automatically replace Ax for the actual value of x. Perhaps someone will come along with it.

---

<div class="post-metadata">

**Author:** ![Mangetout](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mangetout/32/19_2.png) [@Mangetout](https://boards.straightdope.com/u/Mangetout)\
**Post date:** [March 3, 2003, 9:24pm UTC](https://boards.straightdope.com/t/need-help-excel-question/158754/4 "2003-03-03T21:24:16Z")

</div>

> [@](#):
>
> \*Originally posted by xash \*  
> \*\*Perhaps someone will come along with it. \*\*

Um…