who can show me how to use the "if" command and also greater than and less than on excell?

Question

In microsoft excell a person can add and divide and other math. problems, but I have not found an easy way to understand the "if" command : "if" not greater than or less than. Can someone help me find the answer, or instructions?

Answer 1

In a cell type something like the following

=if(expression,value_if_true, value_if_false)

for example:

If Cell A1 has the value 2 in it:
And you want a test in Cell A2 on A1's value, for example, if A1 is greater than 0 you want the word "BIG" displayed, however, if you have a value less than 0 you want that value multiplied by -45. (God only knows why you would want that).
In Cell A2 type the following exactly:
=if(a1>0,"BIG",A1*-45)

then press enter
A2 should now read BIG. (if you have calculations turned on)
Changing A1 to -2 and A2 should then read 90.

Check out Excel's help. It is very useful. I

Answer 2

If statements in Excel can do many things. Here are a few samples:
=if(B4>B2,1) This puts a 1 in the cell if true.
=countif(b2:b100, 4) This will count the number of cells where the value = 4.
=if(d2-d1>0, "true") This will put the text "true" in the cell if cell d2-d1>0.