Using the number that has the higher value

[Albinoass]

Hi all,

I have been playing around with some formulas but can't seem to find the correct one (Probably having a blonde moment)

We have the following:

Volume: 2.27
Actual weight: 300kg
Volumetric Weight (Volume x 167): 379.09
Chargeable weight (The higher number between actual weight and volumetric weight)

How do I get the excel spread sheet to use the higher of the two numbers?

Cheers
Jack

 

[dasadler]

Use the =MAX function. Assuming B1 contains Actual weight and B2 contains Volumetric Weight then use this as the formula in the cell where you want the answer (higher of the two numbers)

=MAX(B1,B2)

 

[Albinoass]

Thanks mate, knew it was something simple ha