If I understand your question, assume A1 contains "3", B1 contains "4" and
C1 contains "6"; and in D1 you want the product of C1 and the greater of A1
or B1,
then use the Formula =IF(A1B1,A1*C1,B1*C1) in D1

Dan
"emerald_dragonfly" wrote in
message ...
I am trying to put together a spreadsheet for calulating transpot costs. I
would like to know if there is a formula to use that will select the
greater
of two numbers. for instance if I had two numbers 3 and 4 and my
calulation
needs to use the larger of the two how do I get excel to do that?