Whatever you put between quotes is treated as text. Try this:
=IF((YEAR(B$8)-YEAR(H30))*12+MONTH(B$8)-MONTH(H30)=10,10,O30)

"Excel Trouble" <Excel wrote in message
...
Say I wanted to write a formula which did this "I want the equation to
show
all values at or above 10 as "10" and I want all values below 10 to show
the
answer as is with no manipulation. So, it would like like this "if 5+6=11
then it will display as 10, but if the two sums are 3+4=7 then the answer
will display as 7 because it is below 10. Again it would be like this "if
17+50=67then it will display as 10, but if the answer to the equation is
below 10 then it will be displayed as that number.

=IF((YEAR(B$8)-YEAR(H30))*12+MONTH(B$8)-MONTH(H30)=10,"10","O30")

The reference cell of "O30"is the problem area I'm running into. It wants
to litterly display the text "O30", instead of the value that is in "O30".
Assuming that value is under 10.