False value

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

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?
 
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.
 
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
 
Thanks a lot, worked fine

JP Ronse said:
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
Click to expand...
 
Back
Top