Cal on a Form

  • Thread starter Thread starter gumby
  • Start date Start date
G

gumby

Why does this not work correctly on a form.

=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]

I do not get the correct answer. What am I doing wrong. I want to be
able to show the avg on the form of several Test Boxes.

Thanks,
David
 
Note that your expresson is = to:
=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]
=2*[T1]*[T2] +
3*[T3] +
4*[T4]/[T5]

Can you send some Tx samples and the result you are getting?

jouj
 
Hi,
I've just realized that you've posted your question again in another thread.
If you did not get a satisfied answer, please send the exact expression
you're writing, some Tx samples and the result you are getting.

Regards,
jouj


jouj said:
Note that your expresson is = to:
=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]
=2*[T1]*[T2] +
3*[T3] +
4*[T4]/[T5]

Can you send some Tx samples and the result you are getting?

jouj


gumby said:
Why does this not work correctly on a form.

=([T1]*1)([T2]*2)+([T3]*3)+([T4]*4) / [T5]

I do not get the correct answer. What am I doing wrong. I want to be
able to show the avg on the form of several Test Boxes.

Thanks,
David
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating on a Form 1
Form for Parts-Tools Lists 0
refer to range in another sheet 5
HLOOKUP PROBLEM 4
Worksheets in Loop 1
How to Retrieve and diplay the details in the form 15
how to do a query of subtraction? 2
Using IndexOf or an alternative? 1

Back
Top