# Calculation using multable fields as alternate formula

Question asked by dansan500 on Jun 3, 2015
Latest reply on Jun 3, 2015 by dansan500

### Title

Calculation using multable fields as alternate formula

### Post

I have tried using an IF statement for this but I can't make it work:

It is a commission calculation

If the price is <\$150 then Price*30% = Commission   there is a setup field for the consignment customer that contains these fields:

Price Level < 150 - this would be the figure entered for that consignment customer

Price Level > 151 - this would be the figure entered for that consignment customer

Percent < - this would be the figure entered for that consignment customer

Percent >  - this would be the figure entered for that consignment customer

Now what I tried to do using the IF statement was:

IF the PRICE is < 150 then use the calculation for price level 1

IF the PRICE is >151 then use the calculation for price Level 2

But I could't get it to work.. Can you help, it's probably simple and I just don't know it...