Excell function not working
Hi all,
We are using Excell portuguese edition and xp with the portuguese language.The problem is when we using formulas it ll not accept ;
for ex:
=se(condition;truevalue;falsevale) is the actual syntax but it didnt work.
we have to use =se(condition,truevalue,falsevale)
Please help me why its behav like this.
Thanks for your help.....
Some versions of Excel use the semi colon as a separator rather than a comma which is used in the UK and US versions. I'm not sure which other versions use which though.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
If your decimal separator is a comma, then the argument separator is a semicolon.
If your decimal separator is a period, then the argument separator is a comma.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
...deleted by me
Last edited by jwright650; 03-03-2011 at 09:51 AM. Reason: moderator posted while I was typing a reply
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks