Stock advisory based on four variables; Urgent, Advice, Not needed and "-"

[Excell_Ensie]

Thank you for having a look at these nested IF functions, im stuck.

I have three columns, minimum stock, maximum stock, actual stock.

If Actual Stock is SAME or SMALLER than Minimum Stock; it should say Urgent
If Actual Stock is LOWER than Maximum Stock but GREATER than Minimum Stock it should say; Advice
If Actual Stock is SAME or GREATER than Maximum Stock; it should say Not needed.
If Minimum stock is 0 it should say; "-"

In the attachement i made a small setup, where I got the help from "thatAndyWard", i have re-posted this because i didnt have the fourth variable earlier.
Im reposting it in here because it was posted in the wrong segment, so that's why im having another go with you guys and girls.

Thank you all for having a look, but more; advice and actual help!

[leelnich]

IN I11 and down:
=IF(E11=0,"-",IF(G11<=E11,"Urgent",IF(G11<F11,"Advice","Not Needed")))

Row\Col	C	D	E	F	G	H	I
10			MIN	MAX	STOCK
11	Battery 12V		1	5	1		Urgent
12	Battery AA		1	5	3		Advice
13	Battery AAA		1	5	5		Not Needed
14	Battery 9V		0	5	0		-

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[Excell_Ensie]

Thank you, but since we are working in different language versions, can I politly ask you to upload the worksheet for me again?

This way it gets auto-translated by Excel.

By altering it towards my Excel, it doesnt give me the proper functioning.
furthermore, but maybe it isn't needed anymore, im missing; IF(AND.
(Supplied by thatANdyWard, earlier, Im hoping his formula just needs a little re-working.)

So please re-up the worksheet for me, so i can have a look Dear Leelnich

Thank you for looking into the matter though!

[leelnich]

If a test yields FALSE, the negative of the same condition is always TRUE, so there's no need to test for it.

=IF(E11=0,"-",IF(G11<=E11,"Urgent",IF(G11<F11,"Advice","Not Needed")))

=IF(E11=0,"-",[else E11<>0]IF(G11<=E11,"Urgent",[else E11<>0 AND G11>E11]IF(G11<F11,"Advice",[else E11<>0 AND G11>E11 AND G11>=F11]"Not Needed")))

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee