Excel Spreedsheet
Posted by Shawn Gerrans on July 22, 2001 3:44 PM
I have a spreedsheet for doing number comparisons.
I have three columns and I need to find the highest number and subtract that from a fourth column.
This is on a per row bases.
Help....Thx
sg
Posted by Ian on July 22, 2001 4:00 PM
Starting as if at A1
In the fifth column put:
=A4-max(A1:A3)
Ian
Posted by Aladin Akyurek on July 22, 2001 4:05 PM
In E1 enter: =D1-MAX(A1:C1) [ copy down this formula as far as needed ]
where I assume A1:C1 to contain numbers of which the highest must be subtracted from yet another number in D1.
Aladin
==========
Posted by Ian on July 23, 2001 2:53 AM
OOPS! Aladins right (of course), it was late and my columns were rows
