# Calculation Help

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

## Recommended Posts

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)

##### Share on other sites

• Newbies

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

##### Share on other sites

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

##### Share on other sites

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

## Create an account

Register a new account

• ### Similar Content

• #### Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,481 views
• #### FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 5,271 views
• #### Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,500 views
• #### Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 3,115 views
• #### Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,743 views
×
×
• Create New...