When using the IF function is there a way to use more sorting filters than just more or less than?

Dear Nick

Thank you for attending Excel 2007 Intermediate course. I hope you enjoyed the course.

There are various types of operators that you can use when you are performing IF statements: Following is an overview with some explanation/examples of them:

Arithmetic operators:
+
-
*
/
%
^ (used for exponentiation e.g. 3^2 = 3*3

Comparison Operators:
=
>
<
>=
<=
<> ( not equal to)

Text operators:
& (ampersand) Connects, or concatenates, two values to produce one continuous text value (B4&C4)

Reference operators:
: (colon) Range operator, which produces one reference to all the cells between two references, including the two references (B5:B15)

, (Comma) Union operator, which combines multiple references into one reference (SUM(B5:B15,D5:D15))

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

I hope this helps!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003