Compare the values and multiply the greater

Solved/Closed
Abid - Mar 13, 2011 at 12:10 AM
 Abid - Mar 13, 2011 at 10:54 PM
Hello,



A B

58.85 503.171

I want to compare the values in Column A and Column B and then multiply the greater with number 24 in a different column, can anyone help me out in this..

Abid

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 13, 2011 at 08:06 AM
you can use Max function to get the max value

=MAX(a1,b1) * 24
0
Thanks Riz
0