=if(a1X,120,0)
This assumes that your number is in cell a1 though. You can change the
number after the second comma to whatever you want.
Hope this is what you want!
Carl
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!
--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile:
http://www.excelforum.com/member.php...o&userid=34352
View this thread:
http://www.excelforum.com/showthread...hreadid=564780