Trying to write an IF statement that will return the following in a new cell.
If the "% replenished/visit" is greater than 20% then return "avg. qty Ord/visit" - otherwise return 0.
However if "% replenished/vist" is greater than 20% and the "std. Dev." is over 2 then add 10% to "avg. qty ord./visit" and if over 3 then add 15% - otherwise do nothing.
<tbody>
</tbody>
<tbody>
</tbody>
If the "% replenished/visit" is greater than 20% then return "avg. qty Ord/visit" - otherwise return 0.
However if "% replenished/vist" is greater than 20% and the "std. Dev." is over 2 then add 10% to "avg. qty ord./visit" and if over 3 then add 15% - otherwise do nothing.
<tbody>
</tbody>
Item | Description | Avg. Qty Ord./visit | Std. Dev. | # of times ordered per Year | % replenished/visit |
1012378 | CUSH WC PREINFLATED SEAT WAFFLE 17X17IN LF N/S REUS | 2 | 0.712312546 | 29 | 12% |
1005993 | DRSG FOAM SOFT SIL SELF ADH SACRUM MEPILEX BORDER 9.2X9.2IN | 8 | 2.644963768 | 16 | 6% |
1004953 | BATT ALK PROCELL SZ AA 1.5V | 22 | 0.630603535 | 19 | 8% |
1004715 | ST PITCHER H2O INSUL FOAM OUTER JCKT LF | 7 | 3.370355089 | 237 | 95% |
1004577 | STRIP TEST BLD GLUCLOSE MNTR ACCU-CHEK INFORM II | 7 | 1.247219129 | 45 | 18% |
<tbody>
</tbody>