MS Excel Help Please - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

MS Excel Help Please

Abz Avatar
6y, 5m agoPosted 6 years, 5 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..
Abz Avatar
6y, 5m agoPosted 6 years, 5 months ago
Options

All Comments

(5) Jump to unreadPost a comment
Comments/page:
#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.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!