If And Statement

[Tony]

Hello,

I have two cells S3 and T3 that can either be "Financed"
or "Not Financed". My financed amount includes or
excludes the amt in cells S3 and T3 depending on if they
are "Financed" or "Not Financed". So, I can have the
cells both say "Financed" or "Not Financed" or one
says "Financed" and the other says "Not Financed".

I think this is an If and statement. The formula I have
now is:
=IF(AND
(S3="Financed",T3="Financed"),AH3*0.85+AH3*0.0282+AM3,AH3*
0.85)

But, the financed amount does not change all the time if
I toggle T3 and S3 back and forth from "Financed" "Not
Financed". It is hard to explain but toggling back and
forth does not calculate properly. There is something
missing from the formula.

Thank you

 

[JulieD]

Hi Tony

i've just had a play with the formula and can't see anything wrong with it
.... are you sure that your workbook calculation is set to automatic not
manual (tools / options / calculation tab)

the formula will only calculate AH3*0.85+AH3*0.0282+AM3 when both S3 & T3
say "financed" in every other situation AH3*0.85 will apply.

Hope this helps
Cheers
JulieD

 

[Tony]

Julie,

I think I figured it out. I used this formula:
=IF(AND
(S3="Financed",T3="Financed"),AH3*0.85+AH3*0.0282+AM3,IF
(AND(S3="Financed",T3="Not Financed"),AH3*0.85+AM3,IF(AND
(S3="Not Financed",T3="Not Financed"),AH3*0.85,IF(AND
(S3="Financed",T3="Not Financed"),AH3*0.85+AM3,IF(AND
(S3="Not Financed",T3="Financed"),AH3*0.85-
AM3+AH3*0.85*0.0282)))))

It seems to work. Thanks for responding though.

Regards,
Tony