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,