answersLogoWhite

0

When you are comparing things, you are doing comparison operations, like checking if one value is greater than another. Different operators are used like:

Greater than >
Less than <
Equals =
Greater than or equal >=
Less than or equal <=

They are used with logical functions like AND, NOT and most commonly the IF. The following formula uses the IF function to compare A2 and 20, and then multiplies A2 by 10 if it is greater than 20, or else multiplies it by 5.

=IF(A2>20, A2*10, A2*5)

User Avatar

Wiki User

8y ago

What else can I help you with?

Related Questions

Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


Who are the creators of Microsoft Excel?

Microsoft excel was created by Microsoft


How do you launch Microsoft Excel?

Programs-&gt;Microsoft Office-&gt;Microsoft Excel


How do you make a professional comparison chart?

You can make a professional comparison chart by using computer software such as Microsoft Excel to create the charts. Alternatively, you can draw one out by hand.


What kind of operation can be done in Microsoft Excel?

Add, subtract, multiply and divide as well as calculating powers. Pretty much anything you can do in math can be done in Excel.


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


Who created Microsoft Excel?

Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.


Is there any hidden game in Excel 2003?

There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.


What is the difference between Microsoft Office Excel and Linux?

Microsoft Word is a word processor. Linux is a family of operating systems.


Different beetwin Microsoft Word Microsoft Excel?

Microsoft Word is used for writing papers, and Microsoft Excel is for spreadsheets.


Which comparison operator means not equal to?

"&ne;" is used in mathematics, though because of the limitations of the Ascii character set then != is often used in programming. In Microsoft Excel, the comparison operator that means "not equal to" is either NOT, or &lt;&gt;.


What computer software use to analyze row and columns of sales figures?

A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.A spreadsheet, like Microsoft Excel or Quattro or Lotus 123.