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
=[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
I assume you have the "/" after the "]" and not inside the "("
RE: DIVIDE AND MULTIPLY
=([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
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
It is basic math idea.
The action in the () will do first.
Dr. Sql
vpathisseril@yahoo.com
Good Luck.