False value

[Khalil Handal]

If BM16 =2 This formula gives FALSE in cell BD16 while it should give the
value in cell BO3.
It works well for all other values.
Cell BN16 might equal "" but not cells BM16 and BP16.

=IF(BN16<>"",BO16,(IF(AND(BP16=0,BM16=1),$BN$3,IF(AND(BP16>3,BM16=1),$BN$4,IF(AND(BP16>3,BM16=2),IF(AND(BP16>0,BP16<3),IF(AND(BP16=0,BM16=2),$BO$3,$BO$4),""))))))

Any suggestions?

 

[Khalil Handal]

Sorry, Forget the posting since there are more problems.
The case is like this: (formula in BD16)

If BN16="" then BD16=BO16
If BP16>4 and BM16=1 then BD16=$BN$4
If BP16>4 and BM16=2 then BD16=$BO$4
If BP16 =0 and BM16=1 then BD16=$BN$3
If BP16=0 and BM16=2 then BD16=$BO$3
If BP16 has values 1, 2, or 3 then BD16=""

Thanks for any help.

 

[JP Ronse]

Hi Khalil,

Try this one.

=IF(BN16="",BO16,IF(AND(BP16>=4,BM16=1),BN4,IF(AND(BP16>=4,BM16=2),BO4,IF(AND(BP16=0,BM16=1),BN3,IF(AND(BP16=0,BM16=2),BO3,"")))))

Wkr,

JP

 

[Khalil Handal]

Thanks a lot, worked fine

Hi Khalil,

Try this one.

=IF(BN16="",BO16,IF(AND(BP16>=4,BM16=1),BN4,IF(AND(BP16>=4,BM16=2),BO4,IF(AND(BP16=0,BM16=1),BN3,IF(AND(BP16=0,BM16=2),BO3,"")))))

Wkr,

JP