So what does the formula give for you when a1=7?
--
David Biddulph

"ginasucasa" wrote in message
...
Thank you. It works for over 8, but:
if a1=7 how do I get b1=7 with the other formula? I want to be able to
use
this formula throughout a worksheet.

"Chip Pearson" wrote:

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!