Vlookup string print new "ORDER"

Originally Posted by Vtomo

I need help in finding a formula to print a new word "ORDER" (in red) on the bottom of a column of numbers when any of the above numbers in the above column is at or less than 400.

Any help will be appreciated.

put formula in cell where you want to show ORDER and format its font colour red.

=IF(COUNTIF($A$1:$A$50,"<=400")>0,"ORDER","")

I suppose that above column is A1:A50, you can change this range according to your data.

hope this is what you required.