none
If condition in Calucuated column RRS feed

  • 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,

    Please try this

    =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.

    SharePoint Server 2019 has been released, you can click here to download it.
    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,

    Any updates ?

    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.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Tuesday, August 13, 2019 1:12 AM