ScottishPeter
New Member
- Joined
- Apr 22, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi everyone,
Struggling I have a fairly large spreadsheet that allows me to highlight when a product if potentially low in stock and at risk of going out of stock.
However I need it to highlight when its already out of stock.
Column F3 has the actual stock holding
Column F4 has the average days cover we have
Column M4 has the average daily sales (days cover) for a large customer.
I have the following formula, =IF(AND(F4<10,M4>10),"Yes","No")
Which shows give us a ‘Yes’ the stock is at risk, if F4 is less than 10 days & M4 is greater than 10 days (ie sales may out strip demand).
However I also need it to give a ‘Yes’ result is the stock holding is already 0.
I’ve been working too long and just stuck, can someone help me out.
Thanks
Peter
Struggling I have a fairly large spreadsheet that allows me to highlight when a product if potentially low in stock and at risk of going out of stock.
However I need it to highlight when its already out of stock.
Column F3 has the actual stock holding
Column F4 has the average days cover we have
Column M4 has the average daily sales (days cover) for a large customer.
I have the following formula, =IF(AND(F4<10,M4>10),"Yes","No")
Which shows give us a ‘Yes’ the stock is at risk, if F4 is less than 10 days & M4 is greater than 10 days (ie sales may out strip demand).
However I also need it to give a ‘Yes’ result is the stock holding is already 0.
I’ve been working too long and just stuck, can someone help me out.
Thanks
Peter