Your Universal Remote Control Center
RemoteCentral.com
Custom Installers' Lounge Forum - View Post
Up level
Up level
The following page was printed from RemoteCentral.com:

Login:
Pass:
 
 

Original thread:
Post 2 made on Monday February 22, 2016 at 12:08
buzz
Super Member
Joined:
Posts:
May 2003
4,379
You can use the general form:

=if(condition, true, false)

example:

=if(a1=b1, "Equal", "Not Equal")

The 'true' and 'false' can be statements:

=if(condition_1, true_1, if(condition_2, true_2, false_2))

Your case is similar to:

=IF(A1>B1,"GT",IF(A1=B1,"Equal","LT"))

---

A little heartburn is the order of calculation, generally left to right, top to bottom. This means that if one cell is calculated and this result is used in another calculation, the first calculation should be left of or above the second calculation.

Last edited by buzz on February 22, 2016 12:17.


Hosting Services by ipHouse