How do you get higher value in excel sheet?

Anonymous

∙ 16y 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

∙ 16y 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.

What is the difference between Excel sheet and spread sheet?

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

How do you make a cover sheet in excel?

Add a sheet

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

What is the formula to copy data from one sheet and to put it in another sheet in Excel?

There is no automatic forumla to copy and paste in excel, unless you write a custom macro. You could use a formula in sheet1 to show the value of a cell on sheet1, like this: In sheet1 put =sheet1!A1

Trending Questions

Facts about dachau concentration camp? Where does mike schneider live? What is lichen planus similar to? How do you return a cat on catz 5? Why are my aglaonema's leaves turning yellow? Who controlled the Berlin wall after world war 2? If you want to take an approval letter from employer to the embassy for a vacation what would be the nature of such? Is GTAgood for your bran? Can a dog get kennel cough after they get that shot? A sentence with the word Stirred? How do you say 'little one' in Russian? When did Albert Gallatin die? He said he loved me and i did to.Then he quit talking to me and then he finally answered my call after2 weeks and he acted like nothing every happened and told me that he didt want to get get to close? What is visible spirit especially one of a terrifying nature? What is the flight path from Glasgow to dominican republic? What type of learing describes when animals learn by listing to others of their species? Why the cells of tapetum in angiospermic plants are multinucleated? Which type of anxiety might be alleviated by starting a 30-minute-per-day aerobic exercise program? How many Oscars did Chris Hemsworth win? Who said Telling a man to go to hell and making him go there are two different things?