Hi there,
I am programming in VBA having set up the Greek Regional settings. This
means that in Greece we use €œ,€� instead of €œ.€� for decimals and €œ.€� instead
of €œ,€� for thousands. I had to pass an excel formula via VBA which is:

Dim num as Double

Num=Cells(1,2).value €˜ this number is 10.1 (10,1 with Greek symbols)
Cells(1,1).formula = €œ=if(€œ & num & €œ=0,0,5)€�

and I got an error message. I also used this formula:

Cells(1,1).formula = €œ=if(€œ & num & €œ=0;0;5)€�

Which is the exact way to input the IF function (;) to Excel with Greek
regional settings but again I got this error. Can anybody give me a good
piece of advice?
Many Thanks