IF OR Statement ?

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to get the syntax of inserting IF M16 = 2800 or 4500, then carry
out a calculation, I've managed it with checking for 2800 but where do I put
the part to check for 4500 in?

See half finished formula below

=IF(M16=2800,INDEX('Master Details'!$A$54:$C$82,MATCH(D16,'Master
Details'!$A$54:$A$82,),MATCH("Subacc",'Master
Details'!$A$54:$C$54,)),INDEX('Master Details'!$A$54:$D$82,MATCH(D16,'Master
Details'!$A$54:$A$82,),MATCH("NoneOps",'Master Details'!$A$54:$D$54,)))



Thanks
 
Back
Top