Forum Discussion

Copper Contributor

Aug 11, 2020

If and ISText formula

hello everyone Good day. https://1drv.ms/x/s!An7MAXsT8f3LhCEcu353KfHzIMZz?e=dPgx5Q I'm currently stuck in my formula, And i need to incorporate logics #4 to #6 to this formula set. =IF(ISB...

excel

SergeiBaklan

Diamond Contributor

Aug 12, 2020

Archie077

Perhaps

=IF( ISBLANK(A2), " new",
  IF(A2="invalid", "closed",
  IF( (A2="valid"),
  IF( ISTEXT(B2),
  IF( ISTEXT(C2),
  IF( ISTEXT(D3),
  IF( ISTEXT(E4),
    "closed",
    "reopen"),
    "assigned"),
    "in progress")
))))