i cant seem to find any problem with my formula

Toggle sidebar Toggle sidebar
Z

ZakiZelani

Honorable
May 20, 2014
45
0
10,530
one of the column is to inform me if i need to replenish my stock. but it it shows #Value! when i put this formula:


=OR(IF([@[Quatity instock]]<10,"Stock Level Is Low","0"),(IF([@[Quatity instock]]=0,"Out Of Stock","0")),(IF([@[Quatity instock]]>10,"Stock Level Is Fine","0")))

do anyone know what is the problem?

excel
 
Solution
S
You need to nest the if statements, you cannot use the OR function like that. If(x>10,"ok",if(x=0,"out of stock"," stock low"))

Replace x for the cell that hold stock value
Sort by date Sort by votes
13thmonkey

13thmonkey

Titan
Jan 10, 2006
24,798
350
75,790
I don't think that you need the Or statement.

if stock < 10 "stock is low"
else
if stock = 0 then " out of stock"
else
if stock >10 then "stock is fine".

=if(qty<10,"Stock low", if(qty=0, "stock zero", if (qty >10, "stock ok",0)))

Note that you have no condition set between 0 and +10
 
Upvote 0 Downvote
Z

ZakiZelani

Honorable
May 20, 2014
45
0
10,530


thanks for replying. I got another problem.
the whole sheet im going to make tracking of the item. but how do I make it blank under the stock level column unless there is something under description column is the item name.

you get what im saying?
 
Upvote 0 Downvote
You must log in or register to reply here.

TRENDING THREADS

Latest posts

Moderators online

Share this page

COMPANY
RESOURCES
FOLLOW
Top Bottom