not sure which function to use

[Karen]

this is probably simple for most of you, but I don't use excell that often...
Here's what I want to do:

Cell F8=(10%*D8)-340 but only if F13="Preferred Title" and F29="Accubanc
Mortgage"

If F13+F29 have something other than the above in them, the I want N/A to
pop into cell F8.

I'm a beginner - bare with me
Thanks
K.

 

[EG]

Try this in F8
=if(and(F13="Preferred Title"; F29="Accubanc Mortgage");(10%*D8)-340)
The result in case that son=mething other happens with F13+F29 will be FALSE.

Eleni Gioka

 

[Jim]

try this!

=IF(AND(F13="Preferred Title",F29="Accubanc
Mortagage"),((10%*D8)-340),"N/A")

hope it helps!

Jim

 

[Steve]

this is probably simple for most of you, but I don't use excell that often...
Here's what I want to do:

Cell F8=(10%*D8)-340 but only if F13="Preferred Title" and F29="Accubanc
Mortgage"

If F13+F29 have something other than the above in them, the I want N/A to
pop into cell F8.

I'm a beginner - bare with me
Thanks
K.

Hi Karen
Try this formula in F8

=IF(AND(F13="Preferred Title",F29="Accubanc Mortgage"),(0.1*D8)-340,"N/A")

HTH
Steve

 

[Karen]

Thank you and bless you!!

Hi Karen
Try this formula in F8

=IF(AND(F13="Preferred Title",F29="Accubanc Mortgage"),(0.1*D8)-340,"N/A")

HTH
Steve