![Old](images/statusicon/post_old.gif)
5th March 2006, 02:44 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
Originally Posted by Twodogs
Could anyone point me in the right direction?
I need a formula for the following! I have 3 columns with the 3 different state divs in them. In the fourth column I want to put the highest div of the 3 columns. Of course in some cases the three divs could be all the same. Anybody have any suggestions it would be greatly appreciated. Thanks Twodogs
|
Assuming you have columns A B C D, with cell A1 containing 4.30 B1 containing 4.6 & C1 containing 4.20 then in column D1 place the following formula:
=MAX(A1:C1)
That should do it with the answer being 4.6 being shown in cell D1.
|