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

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.

Share on other sites

Fitch,

I think that is close. I guess I also need to include that

if cost is empty or zero, price needs to be blank.

Is that possible as well?

Thanks Again.

Share on other sites

Case(

Cost = 0, "",

IsEmpty(Cost), "",

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

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

)

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.

Share on other sites

• 2 weeks later...

Thank you for your help guys.

Share on other sites

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

Create an account

Register a new account