In Excel, the Int function returns the integer (whole number) portion of a number. Be careful though, as if the number is negative, the INT function will return the first negative number that is less than or equal to the number.

The IF function makes a decision regarding values. For example:

The formula in C2 translates as
If A2 is equal to B2 THEN say "Yes" ELSE say "No"
I like to read the commas as THEN and ELSE. Text answers must be placed in quotes (")
<-Previous (H) Next (J)->
|