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?
Answers
Answered by
2
Heya!
Here's your answer!
_________________________
_________
Before knowing anything about which function will be used to determine the maximum value of the of the three numbers.
We must first know what are functions in MS Excel:-
Function:-
MS Excel is a application by Microsoft which helps to create spreadsheet and manipulate and create graphs too. For the users simplification and for convenience it has a inculcated in its package some functions which can be used to calculate the sum product maximum minimum etc, values in different cells.
If there are three numbers in different cells and we need to calculate the maximum value out of the three.
Firstly we need to select those three self and in the fourth cell which will be empty we can use MAX function which is used to determine the maximum value in those three cells
HENXE, THE ANSWER TO YOUR QUESTION WILL BE MAX.
hope this helps you:)
Here's your answer!
_________________________
_________
Before knowing anything about which function will be used to determine the maximum value of the of the three numbers.
We must first know what are functions in MS Excel:-
Function:-
MS Excel is a application by Microsoft which helps to create spreadsheet and manipulate and create graphs too. For the users simplification and for convenience it has a inculcated in its package some functions which can be used to calculate the sum product maximum minimum etc, values in different cells.
If there are three numbers in different cells and we need to calculate the maximum value out of the three.
Firstly we need to select those three self and in the fourth cell which will be empty we can use MAX function which is used to determine the maximum value in those three cells
HENXE, THE ANSWER TO YOUR QUESTION WILL BE MAX.
hope this helps you:)
Similar questions