How to Join "IF" statements together

[Robert110]

Hi

I have a sheet of data, which I need to write "IF" statements for:

The Data is in the attached png file
Ifstat.png

In each row I need to check column H and column F the critiria, but there are many senario's I need to check, so I have writen 9 "IF" statements but I don't know how to join them together (Row 24 is used as an example, but there is many rows that I will need to copy this down to)

IF(AND(H24=" a";F24="SEK");"DO NOT SEND";"OK"),
IF(AND(H24=" b";F24="CAD");"DO NOT SEND";"OK"),
IF(AND(H24=" c";F24=" JPY");"DO NOT SEND";"OK"),
IF(AND(H24=" d";F24=" USD");"DO NOT SEND";"OK"),
IF(AND(H24=" e";F24=" USD");"DO NOT SEND";"OK"),
IF(AND(H24=" f";F24=" MXN");"DO NOT SEND";"OK"),
IF(AND(H24=" g";F24=" EUR");"DO NOT SEND";"OK"),
IF(AND(H24=" h";F24=" DKK");"DO NOT SEND";"OK"),
IF(AND(H24=" i";F24=" NOK");"DO NOT SEND";"OK"),

Please could somebody, tell me how to join these together?
I even thought of using a table and a Vlookup, but my skill are to basis to be able to make this work.
So, I think this would be the best way for me to do this.

Thanks in advance

Rob

[benishiryo]

hi Rob, see if the file helps. i created a table in L24:O32. column N is simply a combination of L & M. so if you can just live without L & M, you can copy & paste the values of column N & delete L & M. then i did a VLOOKUP with IFERROR like this in I24:
=IFERROR(VLOOKUP(H24&F24,$N$24:$O$32,2,0),"OK")

[abousetta]

Hi Rob,

From what you are describing you don't need a nested if statement but rather using AND to make sure all the criteria are correct:

Please Login or Register  to view this content.

Let me know if this works for you.

abousetta

[Robert110]

Hi Benishiryo and Abousetta

Thanks to you both for your quick response.

Both these solutions work really well.

This is great, Thanks again

Rob

[Robert110]

Hi Guys,

I have encountered a different problem with two if statements now and I don't seem able to get these to work in the right way.

Ifstatementproblem.jpg

I have the attacehd data, which has the first condition "If column I is empty then error message "Check - missing bank account" appears, if it has a number in it then "OK"

For this I have made the is if statement =IF(I2="";"Check - missing bank account";"OK")

But their is a second condtion that if column I is empty but column B has "No instruction required" then this is "OK" but if something other than "No instruction required" is in there then "Check - missing bank account" is shown.

I have tried various "IF" and "AND" statement critia, but I just don't seem to be able to get the write result.

Which I would like to be shown in column K.

I know this is a basis thing, but I just don't seem to be able to get it right.

Thanks in advance

Rob

[Kevin UK]

Hi Robert110

For your original question.

Please Login or Register  to view this content.

And for post #5, may be!

Please Login or Register  to view this content.

Sustitute the comma for the semicolon.

[Robert110]

Thanks for your help

Kevin

[Kevin UK]

Hi Robert110

No problem and thanks for the feed back.