problem in excel

[bilbo_mmb]

the first sorry my inglish

I have office 2100 when I write una formula for example =IF(G9=3,"BACK","")

excel say me the formula contains an error.
this excel said me with other formulas.

I understand that is a problem of configuration of excel.I put decimal point but I have same problem

you can help me

[TheTub]

You have office 2100?

I'm not familiar with that version.

Your formula looks fine though.

[bilbo_mmb]

I had excel 2003 and It same hapen

[Leveller]

I'm not sure if it will help, but you may try: depending on your regional settings, Excel uses colon or semi-colon to divide arguments inside function; if it returns error when using colon, try with semi-colon, i.e., this way: =IF(G9=3;"BACK";"")

[bilbo_mmb]

its working

thanks

[bilbo_mmb]

by the way its fornula its good

=IF(G10>H10:"LAYOFFSET:1WITH_GREENING:TRUEFILL_KILL_DELAY:5";"")

i give me error the formula excel