| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter 2 formulas in 1 cell | Excel Discussion (Misc queries) | |||
| enter 2 formulas into 1 cell | Excel Discussion (Misc queries) | |||
| Formulas not filling in without F2+enter | Excel Programming | |||
| Fastest way to enter many formulas | Excel Programming | |||
| Fastest way to enter many formulas | Excel Programming | |||
Linear Mode
