HELP! Please!
 

Hi, I kno this is not a programming query but im a beginner with M
Excel and cant work out why this formula isnt workin! Here goes:

=IF(NOT(ISERROR(MATCH(A1,ValidData,0))),"IIBD ACC","INVALID CAUSE OR P
CODE"),IF(NOT(ISERROR(MATCH(A1,ValidData2,0))),"II BD PD","invalid caus
code")

ValidData is cells H1:H4
ValidData2 is cells I1:I4

this is essentially two IF Statments combined so maybe ive done i
wrong?

Id be really really greatful if anyone can help

Thanx loads,
DCM8

--
Message posted from http://www.ExcelForum.com

HELP! Please!
 

Hi, you need to remove the bracket from after PD CODE" in order to make the
2nd if statement an else.
Jeff

"DCM84 " wrote in message
...
Hi, I kno this is not a programming query but im a beginner with MS
Excel and cant work out why this formula isnt workin! Here goes:

=IF(NOT(ISERROR(MATCH(A1,ValidData,0))),"IIBD ACC","INVALID CAUSE OR PD
CODE"),IF(NOT(ISERROR(MATCH(A1,ValidData2,0))),"II BD PD","invalid cause
code")

ValidData is cells H1:H4
ValidData2 is cells I1:I4

this is essentially two IF Statments combined so maybe ive done it
wrong?

Id be really really greatful if anyone can help

Thanx loads,
DCM84


---
Message posted from http://www.ExcelForum.com/

HELP! Please!
 

Indeed you have.

The first IF resolves completely, as you have both TRUE and FALSE actions,
so you cannot have another IF after this. A second IF should go in place of
either the TRUE or FALSE action.

Maybe this

=IF(NOT(ISERROR(MATCH(A1,ValidData,0))),"IIBD
ACC",IF(NOT(ISERROR(MATCH(A1,ValidData2,0))),"IIB D PD","invalid cause
code"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"DCM84 " wrote in message
...
Hi, I kno this is not a programming query but im a beginner with MS
Excel and cant work out why this formula isnt workin! Here goes:

=IF(NOT(ISERROR(MATCH(A1,ValidData,0))),"IIBD ACC","INVALID CAUSE OR PD
CODE"),IF(NOT(ISERROR(MATCH(A1,ValidData2,0))),"II BD PD","invalid cause
code")

ValidData is cells H1:H4
ValidData2 is cells I1:I4

this is essentially two IF Statments combined so maybe ive done it
wrong?

Id be really really greatful if anyone can help

Thanx loads,
DCM84


---
Message posted from http://www.ExcelForum.com/

HELP! Please!
 

Thanx bob, that worked great!

Only thing is, I realised now that i want to use another two I
statements for the formula that i had 4got to include! Is it possibl
to combine four IF statements together?

I tried using the same principal you gave me on the original two I
statements but excel says i am missing a --) or a (.

Any ideas?

Thanx
DCM8

--
Message posted from http://www.ExcelForum.com

HELP! Please!
 

As ever, show us what you have got so far.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"DCM84 " wrote in message
...
Thanx bob, that worked great!

Only thing is, I realised now that i want to use another two IF
statements for the formula that i had 4got to include! Is it possible
to combine four IF statements together?

I tried using the same principal you gave me on the original two IF
statements but excel says i am missing a --) or a (.

Any ideas?

Thanx
DCM84


---
Message posted from http://www.ExcelForum.com/