MS Excel Help Please - HotUKDeals
Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

£0.00 @
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 … Read More
6y, 11m agoPosted 6 years, 11 months ago
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..
6y, 11m agoPosted 6 years, 11 months ago
Options

(5)
#1
by "inactive" what do you mean? send me it over and i'll take a look. Sounds like a simple IF statement is needed (possibly Nested IF!)
#2
Disco
by "inactive" what do you mean? send me it over and i'll take a look. Sounds like a simple IF statement is needed (possibly Nested IF!)

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
#3
Assuming u have the years in row 1
| 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!
#4
Couldn't see edit button, so here's the table spaced out a bit more:

|---|---A--|---B--|---C--|---D--|---E--|
|-1-|2005|2006|2007|2008|____|
|-2-|____|____|____|____|--XX--|
1 Like #5
Ambdon
Assuming u have the years in row 1| 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!

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.