IF OR Statement ?

[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

 

[Trevor Shuttleworth]

John

=IF(OR(M16=2800,M16=4500),...

Regards

Trevor

 

[John]

Thanks Trevor, perfect

John

=IF(OR(M16=2800,M16=4500),...

Regards

Trevor

 

[Trevor Shuttleworth]

You're welcome. Thanks for the feedback

Thanks Trevor, perfect