CODEWITHSUNDEEP
sharepointconditional-statementsformulacalculated-columns
fiuman007
fiuman007

Reputation: 15

sharepoint: conditional formula for calculated field

i want to create a formula for change my value from EUR into USD. 

FIELD1 (choice): EUR, USD
FIELD2 (number): amount in EUR or USD

Now, if USD is selected in FIELD1 following should happen: calaculate FIELD2*0,71 otherwiese the result is FIELD2.

FIELD3 (calculated): =IF(FIELD1="USD", (FIELD2*0,71), FIELD2))

When I use this formula I get error message: The formula contains a syntax error or is not supported.

Any idea? I´m using english version of WSS 3.0.

Thank you, fiuman007

Upvotes: 0

Views: 2126

Answers (1)

Per Jakobsen
Per Jakobsen

Reputation: 3777

In your formular your using comma as both decimal point and seperator. You have to change one of these.

Which one depends on your regional settings.

If your regional setting are using comma as decimal point then semicolon is usually used as seperator.

Upvotes: 1

Related Questions