IF FUNCTION

[ANGIE]

I WANT TO FILL-IN THE CONTENTS OF A COLUMN (e.g. COLUMN A) AUTOMATICALLY BASED ON THE CONTENTS OF OTHER COLNMNS, USING THE IF FUNCTION.

EXAMPLE: IF COLUMN B CONTAINS TEXT=CANCEL OR CANCELLED, THEN COLUMN A AUTOMATICALLY CONTAINS TEXT=INACTIVE. IF COLUMN B CONTAINS TEXT=YES OR NO, THEN COLUMN A AUTOMATICALLY CONTAINS TEXT=ACTIVE. IF COLUMN B IS BLANK, THEN COLUMN A AUTOMATICALLY CONTAINS TEXT=ACTUAL.

AFTER CONDITIONS CONCERNING COLUMN B HAVE BEEN MET, I WANT TO PROCEDE WITH SIMILAR CONDITIONS REGARDING COLUMN C.

HOW COULD I ACHIEVE THAT???

PLS HELP ME!!!

 

[Jerry W. Lewis]

Use nested IF statements.

=IF(LEFT(B1,6)="CANCEL","INACTIVE",IF((B1="YES")+(B1="YES"),"ACTIVE",IF(ISBLANK(B1),"ACTUAL")))

Jerry

 

[David McRitchie]

You're lucky that Jerry could read your posting in all CAPS.

 

[Jerry W. Lewis]

.. . . IF((B1="YES")+(B1="NO"), . . .

Good catch.

Jerry