shahid5788
Board Regular
- Joined
- May 24, 2016
- Messages
- 91
Hi,
Can you please assist with an IF statement that would have multiple conditions for analysis.
I currently have 3 customers with an associated Part Number. I am trying to find a IF statement that would say if customer ex.A,B,C price is within $10 of each other then "Yes" if not "No". I have listed what I wanted below.
<colgroup><col span="2"><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>
Can you please assist with an IF statement that would have multiple conditions for analysis.
I currently have 3 customers with an associated Part Number. I am trying to find a IF statement that would say if customer ex.A,B,C price is within $10 of each other then "Yes" if not "No". I have listed what I wanted below.
Customer Name | Part Number | Price Me Unit | If Statement what I WANT | |||
AES Electrical, Inc. (Platinum Pkg) | 5C908 | 13 | Yes | |||
FRESNO, City of | 5C908 | 20 | Yes | |||
M&M Management | 5C908 | 6.99 | No |
<colgroup><col span="2"><col span="2"><col span="2"><col></colgroup><tbody>
</tbody>