At this time I use the present formula:

If (b3 10, 0, b3) If b3 is greater than 10 then enter 0 else enter
b3's value

What if I wanted to ask the following:
If b3 is greater than 10 or = to 10 then 0 else b3

How can this be put into a formula?


--
kieffer
------------------------------------------------------------------------
kieffer's Profile: http://www.excelforum.com/member.php...o&userid=30848
View this thread: http://www.excelforum.com/showthread...hreadid=515131