Jump to content

Calculating Price based on cost


MJG
 Share

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

Recommended Posts

I want to calculate price for an item based on cost. It works out as follows:

If Cost is > or = $100, add $100, then round up to next $9.95. If Cost is < $100, double Cost, then round up to next $9.95.

Does this make sense? Is there a way to do this using Price as a calculation?

Thanks, in advance, for any feedback.

Mike

FileMaker Version: 5

Platform: Mac OS X Panther

Link to comment
Share on other sites

Case(

Cost >= 100, Round(Cost + 105, -1) - .05,

Round( (Cost*2) + 5, -1) - .05

)

I'm not 100% confident in this, but I'm sure the mathematicians will chime in.

Link to comment
Share on other sites

Case(

Cost = 0, "",

IsEmpty(Cost), "",

Cost >= 100, Round(Cost + 105, -1) - .05,

Round( (Cost*2) + 5, -1) - .05

)

Link to comment
Share on other sites

Or

Case(Cost,

Case(Cost >= 100, Round(Cost + 105, -1) - .05,

Round( (Cost*2) + 5, -1) - .05)

)

If Cost is empty or zero, the second case will not return a value.

Link to comment
Share on other sites

  • 2 weeks later...

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.