Originally posted by LivingLegend
[b]It doens't with work with me...
Hmm, I guess the problem is my generic translation, I didn't test this on an English system but only on a German one.
Well, the key is to change all the semicolons (😉 to colons (,) because the default separator on UK/US systems is the colon as far as I know.
The following should work for you:
=ROUND(A1+IF(A1<2099,32,IF(A1<2399,24,IF(A1>=2400,16)))*(1-(1/(10^((A2-A1)/400)+1))),0)
{To be more precise the separator in your formula must match the 'list separator' setting in the menu Start>Control Panel>Regional Settings>Numbers>list separator (2nd option from bottom)}
Another issue may be the language EXCEL is using. On my German Excel I have to use RUNDEN instead of ROUND and WENN instead of IF.
I can't believe that they even translated those keywords into German!
Anyway if you are using a dutch version you'll find the proper translation. However, if you are using Chinese ... 😲🙄.
You can get a list of all functions in your language if you hit the function symbol (fx) in Excel which is between the sum symbol and the sort symbol.
Sorry, hope I didn't confuse you too much. If you've problems let me know.
gg