"IF" then questio

[Excel Trouble]

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.

 

[John Bundy]

I haven't tested your logic, but take the quotes off the last 2 items, unless
you want the 10 as text, the "" around O30 will place just O30 in the cell.
Try this:
=IF((YEAR(B$8)-YEAR(H30))*12+MONTH(B$8)-MONTH(H30)>=10,10,O30)

 

[Stephen]

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)