Required an excel formula having part code either,or,both

[PRADEEPB270]

Part Code Part name Unit Qty Rate Amount
1102191 X L 1 40.00 40.00
1104826 Y L 0 40.00 -


Required an excel formula to lookup the part code 1102191 or 1104826 or both,but condition is amount should be >0.01

Part code column=A
Amount Column=F

[Richard Buttrey]

Hi,

The layout is not very useful - a workbook WITH your expected result is always easier.

You'll need to show us what 'amount should be > 0.01' means. What if the result is blank as with the second part code.

Please upload the workbook.

[PRADEEPB270]

please see my attachment for required result