Unable to use most of the important functions in the MS Excel

Himanshu316 

Do you use comma as decimal separator? If so, you should use semicolon between the arguments of a function:

=IF(D6=100; "yes"; "no")