Reply
 
Thread Tools Display Modes
  #1   Report Post  
ll
 
Posts: n/a
Default Subtraction Calculation

I have 2 columns, 3 rows. I'm trying to subtract 2nd column: 1st row minus
2nd. I can't get that formula right. I tried =MIN(b1:b2) or =MIN(b1,b2).
Could anyone tell me what is correct? Thanks. ll
  #2   Report Post  
macropod
 
Posts: n/a
Default

The MIN function simply returns whichever is the lesser of the two values.
It does not do a subtraction. You need =b1-b2.

Read Word's help file for more info or, for a 'tutorial' with examples of
using formulae in Word,
download the Word document at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
(url all one line)

Cheers


"ll" wrote in message
...
I have 2 columns, 3 rows. I'm trying to subtract 2nd column: 1st row

minus
2nd. I can't get that formula right. I tried =MIN(b1:b2) or =MIN(b1,b2).
Could anyone tell me what is correct? Thanks. ll



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.778 / Virus Database: 525 - Release Date: 15/10/2004


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
If field calculation Dawn Rhoads Microsoft Word Help 13 December 10th 04 08:27 PM
Calculation LindaCoedy Tables 4 November 4th 04 03:24 PM


All times are GMT +1. The time now is 06:35 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"