Question

suppose there are three different values in three different cell of ms excel sheet?use if statement to find the greatest of three numbers stored in the cell?

Answer 1

what are you using basic

Answer 2

If you want to find the greatest you need to use “(=MAX(IF [select the cells and close it with two brackets] like this ))

Example “(=MAX(IF$G$2$G$17))”

Or, you can go to the Auto Sum button, press the right-click, select MAX from the drop-down box and select the cells.  You will be able to get the greatest value.