Help with repair workshop, IF statement, returning FALSE

  • Thread starter Thread starter Zak
  • Start date Start date
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.
 
Your third nested If statement is: IF(H10>25,"Stock Excellent!") As you
can see, it contains no "else" parameter. You only told it what to do when
the test is true. Therefore, when it is false, it will just return "false".

HTH
Richard Choate

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.
 
=IF(AND(H10>=10,H10<=25),"Stock OK",IF(H10<=10,"Re-order!!", IF(H10=0,"? or
no
stock",IF(H10>25,"Stock Excellent!"))))


P
 
Zak

=IF(H10=0,"? Or nostock",IF(H10<=10,"re-order!!",IF(H10<=25,"Stock
OK","Stock Execllent")))


Don Pistulka
 
Back
Top