Compare the values and multiply the greater

[Solved/Closed]
Report
-
 Abid -
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use Max function to get the max value

=MAX(a1,b1) * 24