×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

DIVIDE AND MULTIPLY
2

DIVIDE AND MULTIPLY

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:

=([ADMISSION REVENUES]/1.0825)*0.0825

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

=[ADMISSION REVENUES]/(1.0825)*0.0825)

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:

=[ADMISSION REVENUES]/(1.0825*0.0825)

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.

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