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

  • Thread starter Thread starter Jane Humbrey
  • Start date Start date
J

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
 
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.
 
Back
Top