• Hi I need to have a calculated conditional field that calculates the price based on a value.

    Example of excel formula:

    If (Area <=2) , (Area * Price + 300), (Area * Price)

    So if (Area <=2) is TRUE, then it does (Area * Price + 300). If FALSE, then it does (Area * Price).

    I’ve been going through the standard conditions but they don’t seem to be enough to accomplish what I need. I think I need to use a manual formula to achieve this but am not familiar with the code I need to put in.

    Will be great if someone can help me with the code for this!

    Cheers

The topic ‘Help with Manual Formula’ is closed to new replies.