False value

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?
 
K

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.
 
J

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
 
K

Khalil Handal

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...
 
Top