creating a macro

[Guest]

I am creating a sheet that has 3 basic columns. (see below). What I want is
to create a macro that will automatically give me the lowest bid of the
three. I would also like to create a column that shows the differnces in the
three. For example Estimate #1 is $500 more than estimate #2; Estimate #3 is
$700 lower than Estimate #1 and $200 lower than Estimate #2 Can this be done?
A B C
D
ESTIMATE #1 ESTIMATE #2 ESTIMATE #3 BID
$2,000.00 $1,500.00 $1,300.00

Any formula for this?

 

[Bob Phillips]

=MIN(A1:C1)

difference in what, the lowest and the highest, lowest and next? Whatever it
is juts subtract one from the other.

--

HTH

RP
(remove nothere from the email address if mailing direct)