Combining two IF functions

[cacahuatita]

Ok, what i need it this

The overall condition to be checked is K15270=H15270
If M15270="only #", then write "same #"
BUT
IF M15270="Text", then write "same original"
if K15270 is not equal to H15270, then write "-"

My attempt:

=IF(K15270=H15270,IF(M15270="only #","same #",IF(M15270="Text","same original")),"-")

In the "text" cells it gives me "false" instead of "-"

 

[dVBA]

You were just missing the "False" section on your third if statement... I've added it here...

=IF(K15270=H15270,IF(M15270="only #","same #",IF(M15270="Text","same original","-")),"-")

Joshua Smith
dynamicvba.com

 

[cacahuatita]

The formula you posted, dVBA, it's not working properly

It gives me false in every "text"

 

[MrKowz]

This what you need?

=IF(K15270=H15270,IF(M15270="only #","same #",IF(M15270="Text","same original","-"),"-"),"-")

 

[cacahuatita]

Ok, here's what i want the formula to do:

If the info in K and H is the same and M says "only #", then write "same #", but if M says "text", then write "same original", if K and H are not the same, then write "false"

I guess the first step is K=H