Z
Zak
Hi
I am trying to set up a basic stock control for a repair workshop.
However, I cannot figure out what is wrong with this formula:
=IF(H10>=10 <=25,"Stock OK",IF(H10<=10,"Re-order!!", IF(H10=0,"? or no
stock",IF(H10>25,"Stock Excellent!"))))
The H Column refers to a cell that subtracts 'stock in' (column f)
from 'stock out'(column g). The column is called stock balance.
I get the following errors;
I keep getting a 'FALSE' on a number that is between 10 and 24. i want
it to return 're-order'.
And the IF H10=0 then return a '? or no stock' does not seem to work.
I get a 're-order' result
Could someone please point out where the formula is going wrong? I
have tried re-arranging it, but to no avail.
Thank you for your time
Zak.
I am trying to set up a basic stock control for a repair workshop.
However, I cannot figure out what is wrong with this formula:
=IF(H10>=10 <=25,"Stock OK",IF(H10<=10,"Re-order!!", IF(H10=0,"? or no
stock",IF(H10>25,"Stock Excellent!"))))
The H Column refers to a cell that subtracts 'stock in' (column f)
from 'stock out'(column g). The column is called stock balance.
I get the following errors;
I keep getting a 'FALSE' on a number that is between 10 and 24. i want
it to return 're-order'.
And the IF H10=0 then return a '? or no stock' does not seem to work.
I get a 're-order' result
Could someone please point out where the formula is going wrong? I
have tried re-arranging it, but to no avail.
Thank you for your time
Zak.