Don't know what X represents, but assume it is 45

=IF(B145,120)

You posted here, so I'll answer here.


Gord Dibben MS Excel MVP


On Tue, 25 Jul 2006 09:04:02 -0700, SeattleBumm
wrote:

My email address is

I want to have a cell such that if the number in the cell is greater than X,
the formula puts 120 in the cell.

Thanks for your help! Please send me an email if you know how to do this!