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

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.

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.

Case(

Cost = 0, "",

IsEmpty(Cost), "",

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

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

)

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.

Thank you for your help guys.