| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas showing as text rather than values
Bondi wrote:
wardellcastles wrote: I have this formula in a cell =IF(A2=A3,"Match", "NoMatch") However what shows in that cell is the =IF statement itself, not the value "Match" or "NoMatch". Any suggestions are welcome Hi, It could be that your cell is formated at Text. Try to delete the formual and then Format the cell as Generel. Then re-enter the fromula. Regards, Bondi Hi Check your Tools/Options/View tab that Formulas is not checked. Andy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get matching values and formulas from ajoining colums of dropdown | Excel Discussion (Misc queries) | |||
| Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| How do I LOOKUP text values | Excel Worksheet Functions | |||
| Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions | |||
Threaded Mode
