How do I do and if and an and??

[officegirl1034]

I want my formula to say if this =this and that=that then x=y
here's what I have:
=IF('2015 WORK'!U29=DAILY!A137,FALSE)*AND(IF('2015 WORK'!E29=DAILY!$A$134,FALSE)*'if(false,2015 WORK'!A29=DAILY!N137)

I don't know what I'm doing wrong, well I can see several things wrong with this one, but I don't know how to do it right, please help!

 

[Caribeiro77]

Welcome, very confuse...Can you post some practical examples and desired results?
You can use Mr Excel HTML maker ( see how on my signature)

 

[mumps]

Try: =IF(and('2015 WORK'!U29=DAILY!A137,'2015 WORK'!E29=DAILY!$A$134),"",2015 WORK'!A29=DAILY!N137)

 

[Joyner]

Try: =IF(and('2015 WORK'!U29=DAILY!A137,'2015 WORK'!E29=DAILY!$A$134),"",2015 WORK'!A29=DAILY!N137)

This is going to return nothing or TRUE or FALSE, I think the OP want the value in 2015 WORK'!A29 to equal the value in DAILY!N137

Office Girl, if that is correct, let us know.

 

[mumps]

Sorry, my previous suggestion won't work. Try this formula in cell A29 of sheet "2015 WORK": =IF(AND('2015 WORK'!U29=DAILY!A137,'2015 WORK'!E29=DAILY!A134),"",DAILY!A137)

 

[Joyner]

Claudio,

I like that you put the video to the HTML maker. I could never figure out how the members put the bit of stuff below all of their posts...

 

[Caribeiro77]

Joyner, from know on, you don't have excuses to not post some nice samples of your worsheets....

 

[officegirl1034]

Sorry, my previous suggestion won't work. Try this formula in cell A29 of sheet "2015 WORK": =IF(AND('2015 WORK'!U29=DAILY!A137,'2015 WORK'!E29=DAILY!A134),"",DAILY!A137)

I want the value that is on '2015 work'! A29 to be copied into 'daily'! N137
I think I may have had this backwards in the one I sent you... sorry, I switched things around a lot trying to figure it out myself. I did copy this formula into N137 of Daily and changed it to reverse that, but I messed it up I guess, because it returns nothing.

=IF(AND('2015 WORK'!U29=DAILY!A137,'2015 WORK'!E29=DAILY!A134),"",'2015 WORK'!A29)

Sorry for the confusion, thank you.

 

[mumps]

This worked for me in cell N137 of sheet "2015 WORK": =IF(AND('2015 WORK'!U29=DAILY!A137,'2015 WORK'!E29=DAILY!A134),"",'2015 WORK'!A29)