Excel formula

[Mel4342]

=IF(AND(AC3=1,Y3=1),U3,IF(AND(AC3=1,Y3=0),Q3,"NA"))

So I am trying to figure out this formula. Is it reading like this: IF ac3=1 and Y3=1 then result is U3.
If criteria above is not met then look for if ac3=1 and y3=0. If this is true it's q3 but if it isn't its NA

[#2]

@Mel4342 

Isn't it working as desired?

Alternatively, the same formula can be written as below...

=IF(AC3=1,IF(Y3=1,U3,IF(Y3=0,Q3,"NA")),"NA")

[#3]

I am just not the most experienced formula writer. I just wanted to make sure I understood the logic. Does my understanding of it sound correct

[#4]

Yes, your understanding is 100% correct. :thumbs_up: