Thread: how to enter if formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 1,311
Default 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"


Reply With QuoteReply With Quote