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
767
you can use Max function to get the max value

=MAX(a1,b1) * 24

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!