## Forum Discussion

# IF Function not working

- Nov 26, 2023
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?

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

- Riny_van_EekelenNov 26, 2023Platinum Contributor
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?

- tanishakum4gailcomNov 26, 2023Copper Contributor
Riny_van_Eekelen YES IT WORKED! As I changed the semi colons into comma.

IT REALLY HELPED me a lot

Thank You so much