# Fee Schedule Calc need help please

This topic is 7092 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

Hello

I have a fee schedule for buyers fees, It is like if the sale is 1 to 99 dollars then use the contents of the field "feeA" and if the sale is 100 to 200 dollars then get the fee from the field "feeB" and so on. But all the prices are now set up as fields so it needs to be

if the price is between " priceA1" and "priceA2" then the fee is "FeeA"

if the price is between " priceB1" and "priceB2" then the fee is "FeeB"

Can someone show me how to write this calc? Thanks

STANN

##### Share on other sites

Use a lookup. Looks can be setup to use next highest or next lowest value depending on how you set the lookup table.

example

99 FeeA

199 FeeB

299 FeeC

##### Share on other sites

Case( price >= priceA1 and price <= priceA2; FeeA; price >= priceB1 and price <= priceB2; FeeB )

##### Share on other sites

Hi

I tried what you gave me but somehow it works intermittenly. Here is the formula I ended up using

So the field names are a little changed. They are as follows.

"Blockcarprice" is the price of a car

"LowerbuyerA (thru)X " Is the lower end of that schedule and

HighBuyerA (thru) X " is the high end of that schedule

Buyer ( A throughx ) is the total fee assigned for that area of the schedule

So here is the formula that I have used

It works fine for the first few areas up to the "F" section and then it doesn't work.

I just don't know what to do?

STAN

##### Share on other sites

I tried this formula without the case statement but it still doesn't work after the F series. It is working but only intermittently.

This is the new formula I have tried.

I could really use someones' help here

Thanks

Stann

##### Share on other sites

I am so SORRY I have fixed it.

A couple fields were out of order and one was duplicated. I kept checking and checking and it is working fine now.

So sorry if I inconvienced anyone

Thanks

STANN

##### Share on other sites

This topic is 7092 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account