excel formula writing question
 

If your values are listed in column A, use this formula in column B:

=IF(A1=0,"A",IF(AND(A10,A1<2.5),0,IF(AND(A1=2.5, A1<5),1,IF(A1=5,2))))

- Dan

craig phila wrote:
Im using Excel 2003 and I want to have the outcome in one cell contingent
upon the outcome in another. Let me explain:
 If cell €œA1€� = 0, then cell €œA2€� = A
 If €œA1€� = greater than 0 but less than 2.50, then €œA2€� = 0
 If €œA1€� = 2.50 or greater than 2.50 but less than 5.00, then €œA2€� = 1
 If €œA1€� = 5.00 or greater, then €œA2€� = 2

Is this doable? And if so, how is it set up?

--
craig phila