×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# can't figure out formula

## can't figure out formula

(OP)
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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!