Groups

# MS Excel Help Please

Afternoon All,

I need some MS Excel help please...

I have four colums (2005, 2006 2007 etc)

what i need to do is to have an if statement to say the following:

If 2005 is null and 2006, 2007, 2008 etc is null then show as inactive, or if 2005 is not null but 2006, 2007 etc is null then show as in active...

hope that makes sense...

I would say rep left for any help...but i just noticed the rep function no longer exists..

I need some MS Excel help please...

I have four colums (2005, 2006 2007 etc)

what i need to do is to have an if statement to say the following:

If 2005 is null and 2006, 2007, 2008 etc is null then show as inactive, or if 2005 is not null but 2006, 2007 etc is null then show as in active...

hope that makes sense...

I would say rep left for any help...but i just noticed the rep function no longer exists..

Original Poster

When i say inactive its just a word i want to put into a cell....so i just want to know if a customer is an active or an inactive customer...

i wont be able to send over the data as its work related

| A | B | C | D | E |

| 1 | 2005 | 2006 | 2007 | 2008 | |

| 2 | | | | | X |

Put this formula where X is

=IF(ISBLANK(A2)+ISBLANK(B2)+ISBLANK(C2)+ISBLANK(D2)=4,"Inactive","Active")

If the cell is blank, it will return 1, 0 if there is something in the cell... if you have more complicated logic, then you'll have to put nested if's!

|---|---A--|---B--|---C--|---D--|---E--|

|-1-|2005|2006|2007|2008|____|

|-2-|____|____|____|____|--XX--|

You can also use the following that will be quicker to calculate:

=IF(AND(ISBLANK(A2),ISBLANK(B2),ISBLANK(C2),ISBLANK(D2)),"inactive","active")

BFN,

fp.