1st column:

=IF(C2 < D2,C2,0)

2nd column

=IF(C2 = D2,C2,0)

3rd column

=IF(C2 > D2,C2,0)

This repeats five more times in columns, and travels down to row 11, to compare C11 and D11, etc. If the letter A is in cell C5, and the cell to which it is being compared has a value of 80, the helper columns will place 0 in the less than and equal to, but will place A in the greater than column. If A is present in a cell, it should either not be able to compare (apples and oranges) or it should say this is not greater than that and should put 0 in the cell. Is there a way to confirm that whenever A is entered, 0 will be the result of the if?

It is probably worth noting that the formula in D (F, H, J, L, AND N) to which it would be compared is '=ROUND(AVERAGE(SDRUFCS),0)'.

Any help would be appreciated.

Thank you.