how to insert IF function into cell?

Hi I need to insert in cell some IF Function, like this:
=IF(AND($F$3>K5;$F$3<K6);M5;0)
how I can do it?
This is not working:

Please Login or Register  to view this content.

VBA is generally US-centric - as a result you would use US based delimiters, eg:

Please Login or Register  to view this content.

Obviously this can be confusing if you're unfamiliar with the requisite syntax so MS also make available the FormulaLocal property

Please Login or Register  to view this content.

this way you can use your own native syntax

On an aside please always encase Code within CODE tags - even one liners.