Calculation Help

[LiveOak]

Sorry, but how can a cost be <25 and >50 at the same time?

Give this a try.

Case(

Cost <= 25, Cost * 2,

Cost <= 50, Cost + 30

Cost <= 100, Cost + 50

Cost <= 200, Cost + 75,

100)

The last value is a default, if none of the tests succeed. The Case statement performs the tests in order, so an "and" criteria is not needed.

-bd (engineering major)

[delaneyj]

I need some help with a calculation. I have six price points that I need to have a set mark-up applied to. I need to look at the entry in the cost field and then apply the apropriate mark-up. For example, if an item costs from $0 to $25, then it needs to X2, if it is between 26 and 50, it needs to add $30.00 ad so on.

Problem is, I was a communciation major and english minor and do not understand the whole if..then math logic. Any help would be appreciated.

John

[WBlanchard]

Try a Case statement calculated field:

Case(Cost >= 25, Cost + 25,

Cost < 25 and Cost > 50, Cost + 30, Default value)

You can run this as many times as needs to cover the different parameters. The default value would be some value that would be used if all of the cases failed.

HTH