Adding quantity if statement
I'm trying to calculate if an item will still be in stock when used in a certain amount during the week or if I need to buy them and by how much.
Current I have this set up:
A1=18
A2=5
A1 is 18 eggs per box and A2 is the quantity used. My formula is:
=IF(A1-A2*7<=5,"BUY","IN STOCK")
The 7 is from 7 days/week. I want the "BUY" part to look something like: "BUY=1" if it's lower than A2.
Thanks if you can help.
|