If statement based on three conditions 1

[Suggie]

Afternoon,

I have three columns that if they all match this criteria:

Cell 1= PP Review
Cell 2= isblank
Cell 3= Y

Then return the value 1, unless ALL match their criteria, return a blank value "".

I am trying this with the below if(and formula and it won't work. Really fustrating!!

=IF(AND(AH75="PP Review"),1,IF(AND(I75=""),1,IF(AND(I75="Y"),1,"")))

Any Ideas?

TIA,
Mark

 

[bluedragon2]

=IF(AND(AH75="PP Review"),I75="",I75="Y"),1,"")

In your example, you have cell I75 for both the last to conditions. This surely is a typo, or this function will not work.



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

Also, had one to many ) in there, should be:

=IF(AND(AH75="PP Review",I75="",I75="Y"),1,"")


[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Suggie]

Blue,

This doesn't work for me? You are right it is a typo, should be I85, however, I've tried and it is not working.

Should there not be more brackets? Not sure...

Again TIA

 

[TonyJollans]

It appears that cell 2 and cell 3 are the same cell (I75) which means taht the AND condition will always be false.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[Suggie]

Have a star!! That really p*$$ed me off last night...45mins trying to figure it, should go home when I'm tired!!

As always, appreciate the help, nice one.