help with formula

rwc2002

New member
Joined
Jan 8, 2013
Messages
3
Reaction score
0
Points
0
I have been trying to figure out a formula for my inventory sheet with no luck :(
maybe someone can help In the status column id like it to show if reorder is needed or in stock or out of stock i have attached a example of my inventory sheet
 

Attachments

  • example-2.xlsx
    18.7 KB · Views: 15

Canapone

New member
Joined
Oct 3, 2011
Messages
99
Reaction score
0
Points
0
Location
Italy
Excel Version(s)
Excel 2010
Hi,

a first attempt could be in G2:

=IF(E2=0,"OUT OF STOCK",IF(E2<=F2,"REORDER NEEDED","IN STOCK"))

Regards
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
ANother way

=VLOOKUP((E2<F2)+(E2>F2)*2+(E2=0)*3,$H$2:$I$4,2,FALSE)
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
If you reverse the text for items 2 and 3 in your table, you can use

=VLOOKUP(SIGN(E2-F2)+2,$H$2:$I$4,2,FALSE)

which is nicer.
 
Top