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.

use MAX(CELL1:CELLn)

where CELL1 is the first column an CELLn is the last column.

Seemed to work for me.

Good Luck.

Ahh and I see La Mer just beat me to it ....

Thanks for that!!

What if the columns were not side by side?? Say column A, C and E

Twodogs

I think I worked it out!!!

=MAX(A534,C534,E534)

Twodogs

Thanks again for your help!!!

Any ideas on how I can overcome getting an answer #DIV/0! I am using the following formula but the problem is that some of the data is zeros and I get the answer #DIV/0! when it it (0/0)*100.

=('Full Fields'!BZ7/'Full Fields'!BY7)*100

Is there an alternative formula that I could use to overcome this?

Thanks
Twodogs

A simple If soles the problem :


=IF('Full Fields'!BY7 = 0, 0, ('Full Fields'!BZ7/'Full Fields'!BY7)*100)

Good Luck,

=IF(ISERROR('Full Fields'!BZ7/'Full Fields'!BY7)*100,0,'Full Fields'!BZ7/'Full Fields'!BY7*100)


should do it

Thanks Guys

You certainly know your excel. I am learning but slowly.

Cheers
Twodogs