Formula against a specific cell

timward10 , Try using DAX and create a calculated column

DAX
NewColumn =
IF (
AND (
Table[I] = "Optilite Special Protein Analyser",
Table[AO] <> BLANK(),
Table[AL] <> Table[AP]
),
BLANK(),
IF (
AND (
Table[I] = "Optilite Special Protein Analyser",
Table[AL] = Table[AP]
),
Table[AN],
IF (
Table[AM] < Table[AP],
BLANK(),
IF (
Table[AO] <> BLANK(),
Table[AO],
IF (
Table[AK] = Table[AP],
Table[AN],
BLANK()
)
)
)
)
)

Sorry bhanu_gautam  I should of been more discripitive as you've added tables into the above. I have not used DAX query before. Is there a way based on the below? 

I have attached below the PBI report

This is excel report and formula I am trying to replicate. 

=IF(AND($I3="Optilite Special Protein Analyser",AO3<>"",$AL3<>AP$2),"",IF(AND($I3="Optilite Special Protein Analyser",$AL3=AP$2),$AN3,IF($AM3<AP$2,"",IF(AO3<>"",AO3,IF($AK3=AP$2,$AN3,"")))))