If function (with some complexity)

[mneghassi]

Hello

I'm trying to find a way of comparing the value in one cell with the values in multiple cells.

The values in column A contains dates. The values in column B contains all the values I want to compare with each other. To make things a bit clearer, Let's take the value in cell B5 - I like to compare the value in B5 with the value of each of the cells B2, B3, and B4. If B5 is the largest value, return that value. If B4 is the largest value, then return that value; and so on.

Is there a way to use the IF statement to reflect this. Or is there a better function to use in this case?

Thanks!!!

 

[Joe4]

It sounds like you just want to return the maximum value from a bunch of cells.
You should be able to use the MAX function in order to do that, i.e.
=MAX(B2:B5)

See here for more details on the MAX function: https://www.techonthenet.com/excel/formulas/max.php

 

[Fluff]

Why not use the MAX function?
https://exceljet.net/excel-functions/excel-max-function

 

[mneghassi]

Thanks guys. This is perfect. I made it far more complex than needed.

 

[Fluff]

Glad we could help & thanks for the feedback