| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I write an "if then" statement in Excel. eg. If L47 = 0 the
I need to set up a quick way to see if a certain set of data is within the
limits set. I think it was called an "if then" statement. I want to display the word "OK" in cell M47 if L47 is equal to zero. If it is less than zero I want it to display "fix" in cell M47, and if it is more than zero I want it to display "add" in cell M47 I know this formula exsists but I can't find it in my Excel training book. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to write overline in excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| ms excel IF Statement w/pictures? | Excel Worksheet Functions | |||
| How can I write vertically in some columns on an Excel spreadshee. | Charts and Charting in Excel | |||
| SQL Statement and Excel | Charts and Charting in Excel | |||
Threaded Mode
