Hi Zunaid ,
I had to change the regional setting from comma to semi-colon and use semi colon to separate the statements
So mine looks like this
=If(A1=10;5;1)
Fixed
I also wrote this forum under Intermediate instead of Essential
That is where the lesson is .
Thanks
Shallun