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
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Macro to compare two excel sheets ✓ - Excel Forum
How to compare two Excel sheets with varying data ✓ - Excel Forum
Based on the values in cells b77 ✓ - 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

Comparing columns and returning value

Comparing Two Excel Sheets and copying like data to third sheet

VBA Compare 2 sheets and output difference to 3rd sheet

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

Similar discussions

Subscribe To Our Newsletter!