Forum Discussion
IF Function not working
Did you try changing the semi-colons into comma's? The dotted red cell borders indicate that there is a syntax error in the formula.
Did you try the file that I uploaded earlier? How do the formula's show when you open it?
Riny_van_Eekelen please go ahead with the data that I have provided in my concerned post as i have non other option
tanishakum4gailcom Well, you just mention that "the output is wrong". That's quite vague.
Perhaps you have 'Show Formulas' enabled. Then Excel just shows the formula but not the result, or you should be using a comma to separate the function arguments, or there are leading / trailing spaces in the Type 1 column. Many different reasons why the output may be wrong.
See if the attached file provides the correct output then.
So please let me know from where can I switch this feature(SHOW FORMULA) to get the output.
On the Formulas ribbon, look for the 'Show Formulas' button (top right in the picture below). If it it has a dark background it enables and will show formulas. Press it again the deactivate it and Excel will show the results.
Riny_van_Eekelen well i did the same but nothing happens
