IF AND Formula help

[EvansB2]

Hi there,


I have inserted the following formula and it hasn't worked. It is fairly straightforward in that if cell Y3 had either "Invoiced" or "Part Invoiced" input then return the value in cell W3, otherwise return zero.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(Y3="Invoiced"(AND(OR(Y3="Part Invoiced",W3,0))))

Any help would be gratefully received as will save me hours of work!

Regards

Ben

[/FONT]

 

[jimrward]

=if(OR(y3=“inv”,y3=“part”),w3,0)

 

[EvansB2]

Apologies for the late reply, I have just realised that I need to update my email address having moved companies!

I'll give it a whirl and hopefully get going

Ben