How can we get the subtraction of values in first 2 columns in the 3rd column

[Jane Humbrey]

Hi Friends

Greetings. If I have the following 500 row excel file, how can we get the
subtraction of first two columns(Col3)?. I couldn't find any subtraction
function in microsoft excel 2000.

Col1 Col2 Col3(I want the subtraction of Col1-Col2)
------ -------- ----------
$50 $30 ??(I want $20 here)
$100 $40 ??(I want $60 here)
$150 $25 ??(I want $125 here)
--- ---- ---
--- ---- ---


Thank you
Jane Humbrey

 

[Norman Harker]

Hi Jane!

Use:

=A1-B1
Copy down parallel to your data.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Jane Humbrey]

Hi Norman

Thank you so much. It's working well.

Jane

 

[Peo Sjoblom]

Next time just post in one NG, it is considered impolite to multipost