Wrong Formula

**usmanfarok** · 06-25-2012, 02:59 AM

can anybody help me with the following formula, i think i got some thing wrong

=IF([@Stock]<5000,([@Class]="Fast",10000, 5000),"0")

the logic is if the stock is below 5000 and the items is classified as a fast moving item automated order of 10,000 should be placed otherwise 5000 if slow moving item, and if the stock is above 5000 no need to place the order.

i hope i explained it well, thanks in advance

Usman

**dilipandey** · 06-25-2012, 03:11 AM

Hi Usman,

May be :-
=IF(and([@Stock]<5000,[@Class]="Fast"),10000, 5000)

Regards,
DILIPandey

<click on below 'star' if this helps>

**vlady** · 06-25-2012, 03:24 AM

from dilip's

=if([@Stock>4999,0,IF(and([@Stock]<5000,[@Class]="Fast"),10000,5000))

**usmanfarok** · 06-25-2012, 03:27 AM

thanks, i have already sorted it, anyway thanks for the advise i will keep this too

many thanks once again for the quick response

**usmanfarok** · 06-25-2012, 03:35 AM

Dilip have u looked at the other file i sent you, it was a part of it its already sorted but i am still struggling on the orders status, can you please help me on that part

Originally Posted by dilipandey

Hi Usman,

May be :-
=IF(and([@Stock]<5000,[@Class]="Fast"),10000, 5000)

Regards,
DILIPandey

<click on below 'star' if this helps>

**Pepe Le Mokko** · 06-25-2012, 03:59 AM

Originally Posted by usmanfarok

Dilip have u looked at the other file i sent you, it was a part of it its already sorted but i am still struggling on the orders status, can you please help me on that part

has there been a change in rules about sending questions via PM?

**dilipandey** · 06-25-2012, 04:04 AM

Hi usmanfarok,

Where you have sent the file?
Suggest you to uplad the file. . while replying click on Go Advanced.and look for paper clip icon to attach. Thx

Regards,
DILIPandey

<click on below star if this helps>

**usmanfarok** · 06-25-2012, 04:20 AM

sorry i meant to say upload the file but said sent the file its is already uploaded in the following link

http://www.excelforum.com/excel-gene...on-tricky.html

hops you look at it.

thanks in advance

Usman