IF (Primitive Spread Function) returns a value based on a logical value.

SYNTAX:

IF(value1,value2,value3)

REMARKS:

value1 must be or evaluate to numeric data, where nonzero values indicate True, and a value of zero indicates False. If value1 is nonzero (or True), then value2 is returned. If value1 is zero (or False), then value3 is returned. value1 can contain one of the relational operators: greater than (>), less than (<), equal to (=), or not equal to (<>). 

EXAMPLES:

IF(A3<>2000,1900,2000)
IF(C4,B2,B4)
IF(1>2,5,10)=10
IF(1<2,"dogs","cats") equals dogs

SEE ALSO: Case Spread Function