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
"Compare versions word" - Guide
Beyond compare download - Download - File management
Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme - Programming Forum
Based on the values in cells b77 b88 ✓ - Excel Forum
How to compare two different columns - 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

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

Fill adjacent cell with number from text answer

Name Values

Excel function question

Similar discussions

Subscribe To Our Newsletter!