×
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.

# DIVIDE AND MULTIPLY2

 Forum Search FAQs Links MVPs

## DIVIDE AND MULTIPLY

(OP)
I still cannot get this to work:
=[ADMISSION REVENUES](/1.0825)*0.0825  --this is going to a field named "Amusement Tax".
What am I doing wrong?
Thanks again,
Gwen

### RE: DIVIDE AND MULTIPLY

what result are you getting?

I assume you have the "/" after the "]" and not inside the "("

### RE: DIVIDE AND MULTIPLY

I'm not sure which way you want it but if you want the result of ADMISSION REVENUES divided by 1.0825 to be  multiplied by 0.0825, then it needs to be:

If you want ADMISSION REVENUES to be divided by the result of 1.0825)*0.0825, then it needs to be:

HTH
RDH

Ricky Hicks
rdhicks@mindspring.com

### RE: DIVIDE AND MULTIPLY

I made a mistake in the last post. In the second calculation it should have been:

If you want ADMISSION REVENUES to be divided by the result of 1.0825)*0.0825, then it needs to be:

Sorry,
RDH

Ricky Hicks
rdhicks@mindspring.com

### RE: DIVIDE AND MULTIPLY

Always careful with the () and mutiply and divide cases.
It is basic math idea.
The action in the () will do first.

Dr. Sql
vpathisseril@yahoo.com

Good Luck.

#### 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.

#### 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:

• 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!