How do you get higher value in excel sheet?

Anonymous

∙ 15y ago

Updated: 8/17/2019

The Max function will give you the highest value in a range of cells. So if you have numbers in all the cells from A1 to A15 and want to know what the highest one is, you would use the following formula, which you put into another cell outside of A1 to A15.

=MAX(A1:A15)

Wiki User

∙ 15y ago

What else can I help you with?

How do you make a result sheet in Excel?

how to create a excel sheet

How you delete formula in excel sheet without deleting value?

we can use the option copy and then past special value.

What is the full form of PFA in Excel sheet?

Pfa the excel sheet

What is v - look up?

VLOOKUP is a function of Microsoft Excel. You can use VLOOKUP to find a value in a table or list on an Excel sheet. It looks at a value in a column and finds the corresponding value in another column in the same row.

Is 8.4999 return a value of 8 in Microsoft Excel sheet?

=ROUND(8.4999,0) function will return 8.

How do you make a cover sheet in excel?

Add a sheet

What is the difference between Excel sheet and spread sheet?

They are the same thing, excel is Microsoft's spreadsheet programme.

How do you link data in a row on excel master sheet to row on another sheet on Mac Excel 2011?

Use the name of a sheet, followed by an exclamation mark and a cell reference. The following would take the value in cell C21 on Sheet2 and put it wherever the formula is typed. =Sheet2!C21

How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?

Calculating DSCR in Excel sheet

How is a sheet made active on excel 2007?

Select the sheet.

What is a model in excel?

A spread sheet

How many cells in a 2007 Excel sheet?

17,179,869,184 cells in one excel