close

Greetings,

I have searched the Forum and have not found the answer. If you know the
link post it and I will look there.

I want to take the number 500 in one column and amp; place a Percentage like
10% in the next column and it add the two columns with a result of 550 in the
third column.

This is the only function I need, I don't need a total at the end of the
page or anything like that.

Thanks for the help

Allen

=(A1*B1) A1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;Allenquot; gt; wrote in message
...
gt; Greetings,
gt;
gt; I have searched the Forum and have not found the answer. If you know the
gt; link post it and I will look there.
gt;
gt; I want to take the number 500 in one column and amp; place a Percentage like
gt; 10% in the next column and it add the two columns with a result of 550 in
gt; the
gt; third column.
gt;
gt; This is the only function I need, I don't need a total at the end of the
gt; page or anything like that.
gt;
gt; Thanks for the help
Allen, here is one way, with 500 in A1 format cell B1 as percent then put in
10 in C1 put =A1*B1 A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Allenquot; gt; wrote in message
...
gt; Greetings,
gt;
gt; I have searched the Forum and have not found the answer. If you know the
gt; link post it and I will look there.
gt;
gt; I want to take the number 500 in one column and amp; place a Percentage like
gt; 10% in the next column and it add the two columns with a result of 550 in
the
gt; third column.
gt;
gt; This is the only function I need, I don't need a total at the end of the
gt; page or anything like that.
gt;
gt; Thanks for the help

--
Tagliaquot;Allenquot; wrote:

gt; Greetings,
gt;
gt; I have searched the Forum and have not found the answer. If you know the
gt; link post it and I will look there.
gt;
gt; I want to take the number 500 in one column and amp; place a Percentage like
gt; 10% in the next column and it add the two columns with a result of 550 in the
gt; third column.
gt;
gt; This is the only function I need, I don't need a total at the end of the
gt; page or anything like that.
gt;
gt; Thanks for the help

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()