You can do this with the MIN function. In cell B1, enter

=MIN(A1,8)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"ginasucasa" wrote in message
...
I'm in need of the following:
a1=9

Formula: If a1 is greater than 8, I need b1 to show 8 only. If it is
less
than 8, I need it to show the amount that is less than 8.

So b1 on this should show 8.

Thanks!