LinkBack URL
About LinkBacks
Hello,
I want to use a dutch formula in vba, so i need to translate it, but i cannot get the english version to work.
Can anyone help me: AFRONDEN.BENEDEN.NAUWKEURIG(C.WORTEL((ABS(A5-C5))^2+(ABS(B5-D5))^2))
Hello,
I want to use a dutch formula in vba, so i need to translate it, but i cannot get the english version to work.
Can anyone help me: AFRONDEN.BENEDEN.NAUWKEURIG(C.WORTEL((ABS(A5-C5))^2+(ABS(B5-D5))^2))
Last edited by mdek; 08-08-2016 at 01:12 PM.
Please post questions in other than English in http://www.excelforum.com/non-english-excel/
Entia non sunt multiplicanda sine necessitate
I will move it there
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Are you using complex numbers? If not, why the imaginary square root (C.WORTEL) instead of just SQRT (WORTEL)?
Re: Vertaling formule
Hi !
Originally Posted by mdek
Of course you can ‼ Just enter your formula within a cell, when result is right,
cell must be active (selected) then see in Watch VBE window what returns ?activecell.formula !
Sorry for the late reply - only just saw this.
According to this very useful website: http://en.excel-translator.de/translator/
the formula translates to:
Formula:
Please Login or Register to view this content.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks