Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

can't figure out formula

can't figure out formula

can't figure out formula

Made inventory program for work (use v9.8)and need it to do calculation which I can't get no matter what have tried.  Made field called Cost and another called Retail.  I need it to take whatever I enter in the Cost field and have that figure calculated to get retail cost and insert into Retail field.  

Example if Cost is $5 or less then take the info in the Cost box and multiply it times 5 and that answer goes in the Retail box but I can't even get it to do that let alone finish all the multipliers (there are like 6) meaning we need if Cost is <5 then Cost x 5, if Cost is <10 then Cost x 4 etc

Can anyone help us on this formula we need to make?
Can it be done in the 1st place?
I needed it to take Retail and discount that 20% for another field and I got that formula to work fine but can't get the other at all

RE: can't figure out formula

The easiest way to do this is with a calculated field for your complicated formula. It is then a simple algebra-like formula: If(cost <= 5, cost * 5,If(cost <= 10, cost * 4, etc. Just make sure the parentheses match up. This makes it easy to test because you can put the calculated field on a worksheet or form to see if it works.

Then you can put the name of the calculated field in the Field Definition modification formula.

Sue Sloan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close