On Tue, 14 Jun 2005 05:49:01 -0700, "Patience"
wrote:

Is there any way to write a formula that will examine the cell contents, and
return one of three different values?
I want the formula to look at column A, and if column A value is less than
100, return "50", if it's 100 or more, to return "100", and if it's null or
0, to return "0."
I'm using Office 2003
Thanks,

=IF(A1=0,0,IF(A1<100,50,100))


--ron