answersLogoWhite

0

Formula in excel for more than?

Updated: 11/7/2022
User Avatar

Wiki User

14y ago

Best Answer

It isn't totally clear what you are saying you want to do. The greater than symbol can be used for more than, but you may be wanting to do other things, like make a choice based on whether a value is more than something or not. In that case you need other functions, like the IF function. See the related link below for ways that can be used, which does include some choices based on testing whether a value is more than something or not.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Formula in excel for more than?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can And Excel formula include more than one operation?

Yes it can.


When more than one arithmetic operater is involved in a formula Excel follows an order from left to right in a formula calculation?

Order of Operations


What is underlying formula in Excel?

An underlying formula in Excel is used in a spreadsheet to do something different than the formula does. An underlying formula can be used to remove values or display numbers.


Can an Excel formula include more than one operation?

Yes. Excel formulas can be very complicated, consisting of many operations and other elements, such as functions.


When more than one arithmetic operator is involved in a formula excel changes the year to?

Excel does not change the year if the arithmetic operators have been used with the correct syntax.


When more than one arithmetic operator is involved in a formula Excel follows the same basic order of?

Order of Operation.


Does an Excel complex formula use more than one arithmetic operation?

A complex formula in Excel could have many arithmetic operators in it. There are many things that make a formula complex, so a formula with just one arithmetic operator or even no arithmentic operators could be complex too, depending on what it does.


When more than one operator is involved in a formula Excel follows a different basic order of operations from that used in algebra.true or false?

False. Excel follows the rules of mathematics in doing calculations, as algebra also does.


When more than one arithmetic operator is involved in a formula Excel follows the same basic order of that you use in algebra?

Order of Operations


What are the 20 function in excel?

It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.