Question

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

Answer 1

Excel worksheet. 

We need to write a function in a cell to find the greatest of three numbers stored in three different cells.

Suppose A1, B1 and C1 are the cells containing three numbers. We want cell D1 to contain the maximum of the three. So in D1 we write the following function.

    =if((if(A1>B1,A1,B1))>C1,(if(A1>B1,A1,B1)),C1)

Alternately , the following function can be written too:

           =MAX(A1:C1)
       or  =MAX(A1,B1,C1)