I am having problems with"if,"

I'm assuming you are having problems with syntax.

The basic syntax for an IF statement is:

IF(test,value_if_true,value_if_false)

There are no spaces between values and commas.

True or False values can be set numbers, calculated numbers (must input the function), text strings, contents of other cells, etc. If the values are text strings, enclose the text string in parentheses.

If you want run multiple tests on a cell, you can nest up to 7 IF statements.

Sample syntax:

Simple: IF(B3<=120,"OK","Over Budget")
This statement checks to see if the value in cell B3 is less than or equal to 120. If it is, it returns the text string OK and places in the cell where the IF statement resides. Otherwise the text string Over Budget is placed in the cell.

Difficult (nested): IF(B3>89,"A",IF(B3>79,"B",IF(B3>69,"C",IF(B3>59,"D","F"))))
This stement assigns a letter grade based upon a numerical score. Except for the last IF statement, the FALSE value for each IF statement is another (nested)IF statement.

Hope this helps.