how to enter if formulas
 

How do you enter a formula that says if a cell is equal to or less than 5
type the text "reorder" if the cell is more than 5 type text "leave"

how to enter if formulas
 

=IF(A1<=5,"reorder","leave")

HTH,
Paul

--

"Brian555" wrote in message
...
How do you enter a formula that says if a cell is equal to or less than 5
type the text "reorder" if the cell is more than 5 type text "leave"

how to enter if formulas
 

Have you tried the help index for
IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brian555" wrote in message
...
How do you enter a formula that says if a cell is equal to or less than 5
type the text "reorder" if the cell is more than 5 type text "leave"