1 of 3 choices to display in cell based on fulfillment criteria

[dataguy]

In cell A2 I want the text Complete / Incomplete / Credit Given to appear based on completion of other cells. The complete/Incomplete part works fine, but I want A2 to change to "Credit Given" when a user enters ANY text into cell T2.

The existing formula displays Complete or Incomplete via a COUNT formula in M2 that returns a value for how many blank cells there are from B2 to L2. So if a user enters something in all cells, M2 says there are "0" blank cells, and the formula in A2 interprets this as "Complete".

Tis is in A2:
=if($M2=0, "Complete",if(and($M2>0,$M2<10),"Incomplete"," "))

The false condition is simply a blank space so A1 appears to be blank if no one has entered ANY information.

So - now I want to amend this formula to take into account a subsequent entry into T2 to change the (properly displaying) Complete/Incomplete into "Credit Granted".

Thanks!!:confused:

[tigeravatar]

dataguy,

Welcome to the forum!
Perhaps...

Please Login or Register  to view this content.