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

What is another name for middle aged people? What prophet was tragic and his message was not often accepted but never lost hope? What language does the word 'data' come from? How do you spell responsibility in Sign Language symbols? Where are the knuckles located on the body? Define psi and explain what is full in any size tank? How wide is the 2003 Land-Rover Range-Rover? What size shell is a 7.62x54mm rifle? Who is stronger a Vulcan or a Klingon? What are three weaknesses of hades? What is the meaning of number 3 4 and 5 soccer ball besides the size What do the numbers stand for? What damage does dyeing your hair with wash in wash out do? How many chocolate chips are in an ounce? What is the recipe for elephant bars citrus cheesecake brulee? What is the symbol of a rational number? How do you hire taxi in London? Do a occupational therapy assistant have to be licensure or have testing? How can you get wiring diagrams of Isuzu elf 4hl1-1 ecu? When cabruy start making chocolate? Professor quantum has two coins which total 35 cents since one of the coins is not a dime what are the two coins?