MJG Posted April 20, 2004 Share Posted April 20, 2004 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 More sharing options...
Fitch Posted April 20, 2004 Share Posted April 20, 2004 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 More sharing options...
MJG Posted April 20, 2004 Author Share Posted April 20, 2004 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. Link to comment Share on other sites More sharing options...
Fitch Posted April 21, 2004 Share Posted April 21, 2004 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 More sharing options...
-Queue- Posted April 21, 2004 Share Posted April 21, 2004 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 More sharing options...
MJG Posted May 3, 2004 Author Share Posted May 3, 2004 Thank you for your help guys. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7297 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 accountSign in
Already have an account? Sign in here.
Sign In Now