Combining two IF functions

[cacahuatita]

Ok, Here we go.

What I need this formula to do is:

If B1 is different from A1 and E1 says "TEXTO" then "DONE" if not "-" but if E1 says "PURO#" and B1=A1 then "DONE" if not "DIF#"

My colums' names are:
A - "English"
B - "Spanish"
D - "Extra info"
E - "English match"
F - "Numbers or text"
G - "Translation added"

So, I have both text and numbers in columns A and B, and I translated the text, but the numbers, well those don't need translating, so what I want is to check if I pasted the information on the TEXT cells right and at the same time check if I didn't change any NUMBERS by mistake. In column E I already used a formula to check if a cell contained only numbers, and used paste special to keep tha values and not the formula in the cell.

I thought I could make a formula with two if functions together combined with "or" or something like it, but excel has once again outsmarted me.

I hope I'm clear enough. Please explain as if you were talking to a five year old...I suck at excel formulas

 

[MrKowz]

Try:

=IF(OR(AND(B1<>A1,E1="TEXTO"),B1=A1),"DONE","DIF#")

 

[cacahuatita]

I think I wasn't clear, the formula should be something like:


=IF((H1=I1,M1="PURO #","#")or(H1=I1,M1="Text","-","DONE"))

But, of course, my stupid formulas are not right and I'm losing my mind

I'd appreciate an explained answer like:
=if(and(this=that,something else=something else),do this if true,do this if false)

 

[Scott Huish]

=IF(H1=I1,IF(M1="puro #","#",IF(M1="Text","-","DONE")),"")

 

[cacahuatita]

In the end I used:

=IF(H1=I,IF(M1="puro #","#",IF(M1="Text","-")),"DONE")

and it's working great!

Thanks soooo much!