# If condition in Calucuated column

• ### Question

• If  currency = euro  then caluculate cost * 70

if currency =USD then caluculate cost* 80

if currency =INR then caluculate cost* 100

how to caluculate this in caluculate in sharepoint , please guide me

Tuesday, August 6, 2019 1:17 PM

### All replies

• Hi,

Assuming you have two columns in your list named "currency" and "cost".

You can use below formula for your requirements:

`=IF([currency]="euro",[cost]*70,IF([currency]="USD",[cost]*70,IF([currency]="INR",[cost]*100,0)))`

You can find more details about IF condition in below article:

IF function

Tuesday, August 6, 2019 1:29 PM
• Hi Mkbprasan,

=IF([currency]="euro",[cost]*70,if([currency]="usd",[cost]*80,if([currency]="inr",[cost]*1000,[currency])))

Enjoy the SharePoint !!

Best Regards,
Krishna

If this Post helps you, then please don't forget to mark it answer or Vote for this post.

Tuesday, August 6, 2019 1:32 PM
• Hi mkbprasan,

I tested the formula from the posts above and it will work as expected:

You can Mark the helpful reply as answer so that it could also help others in the forum.

Thanks

Best Regards

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

Wednesday, August 7, 2019 3:03 AM
• Hi mkbprasan,