New user need help

[B2B]

HI ALL
I HAVE SOME EXCEL'S BACKGROUND
BUT I FACED A SMALL MISTAKE WHEN I WOULD LIKE TO MAKE THE FORMULA
MY CASE IS :
I HAVE A 2 COLUMN ( EDUCATION , YEARS )
A B C
EDUCATION YEARS RESULT
1 BS 1
2 MBA 2
3 HIGH SCHOOL 2
4 DIPLOMA 2
5 MBA 1
6 HIGH SCHOOL 1.5
7 DIPLOMA 3

I NEED TO ADD A FORMULA IN COLUMN C \"RESULT\" AS A TRUE OR FALSE T
FOLLOW THIS CONDITION
IF(A1=\"HIG
SCHOOL\",A1=\"DIPLOMA\",B1>=1),(A1=\"\"MBA\",A1=\"BS\",B1>=2)
I DID THE ABOVE FORMULA BUT UNFORTUNATELY NOT WORKING

PLEASE IF ANY ONE CAN HELP ME TO SOLVE THIS, I WILL APPRECIATE

YOUR COLLEGE
B2

 

[via135]

hi!

do you want the result in COL C in terms of "Education" or "Years"?

-via135

 

[B2B]

Hi
Both of thim Education & Years

Thank you for your intersting

B2

 

[Sandy Mann]

B2B,

With the headers in A1:C1 and the data in A2:B8 then:

=IF((B2>=2)*((A2="MBA")+(A2="BS"))+(B2>=1)*((A2="High
School")+(A2="Diploma")),TRUE,FALSE)

will give you the required TRUE/FALSE

Note: If this is a homework question I would expect your teacher to be
asking you how yuo arrived at this method.

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[B2B]

HI
SPECIALLY SANDY


BINGO


it is work thanks for all
and i am not a student
i am a HR advisor

B2

 

[Sandy Mann]

You're Welcome. I didn't mean to be derogatory by adding the comment about
a teacher, it was just that I found the request for a TRUE/FALSE response
odd - I would have expected something like a request for a 1/0 response so
that the answers could be added up.

The *conventional* way of writing the formula would be:

=IF(OR(AND(OR(A2="High
School",A2="Diploma"),B2>=1),AND(OR(A2="MBA",A2="BS"),B2>=2)),TRUE,FALSE)

If a 1/0 response would be acceptable then my original formula could be cut
down to:

=(B2>=2)*((A2="MBA")+(A2="BS"))+(B2>=1)*((A2="High School")+(A2="Diploma"))

--
Regards

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk