View Single Post
 
Old 06-21-2014, 04:23 PM
ImAhNoBoDy ImAhNoBoDy is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jan 2012
Posts: 17
ImAhNoBoDy is on a distinguished road
Default 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.
Reply With Quote