Forum Discussion
Solved
IF Function not working
I have a workbook with different sheets in which I have done many Function in each sheets at one time. I did "IF" function in a sheet but the output is wrong. IF function has satisfied all the condi...
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?
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
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 YES IT WORKED! As I changed the semi colons into comma.
IT REALLY HELPED me a lot
Thank You so much
