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

Compare the values and multiply the greater
Beyond compare - Download - File management
Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
Excel compare two sheets - Guide
To convert ounces to milliliters multiply by - Excel Forum
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum

1 response

Answer 1 / 1

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

Abid
Mar 13, 2011 at 10:54 PM

Thanks Riz

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Excel function question

Return Seq Values Until Blank value then return different set of seq values

Clear cell contents based on value of another cell range using VBA

Similar discussions

Subscribe To Our Newsletter!