If then statement help

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello

I am wondering if an "if then" statement can include
an "&" in the logical test part (aka the first part). I
tried and it did not give me an error but it did not do
what it should have done.

The formula I thought would be correct:
=IF(E2="Insured"& T2="Financed",0.0282*AG2,0)

the & part seems to be incorrect because it does not give
me the correct answer. It returns the value of 0 but the
value in E2 says "Insured" and T2 says "Fianced". I am
guessing there can not be &statments with if/then
statements or my syntax is incorrect.

Let me know if someone knows if you can use "&"
statements with "if then" statements and the correct
syntax.
 

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

HELP! I need to make an IF Statement comparing date/time fields.. 2
If And statement 6
If And Statement 2
If then nested statement 7
Writing an "IF" Statement 2
IF STATEMENT 19
IF Statements 9
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1

Back
Top