Divide by 12

--

HTH

Bob

"Scoober" wrote in message
...
Hi Tom,

Sorry your formula has worked (i Has something written in e32)

Can you tell me how to make this answer in a monthly amount as it is
showing
in a yearly figure (something i did not think about in my original
question)
--
Thanks in advance.

Scoober


"Tom-S" wrote:

Try this:

=IF(OR(H31<18142,H33<18142,AND(E31="no",E33="no")) ,"",(SUMPRODUCT((E31:E33="yes")*(H31:H33))-COUNTIF(E31:E33,"=yes")*18148)*0.1)

Please note, this assumes that cells E32 and H32 are both empty.



"Scoober" wrote:

Hi all,

I am trying to get this formula to complete a student loan formula.

=IF(AND(H31=H33,H31="no"),"",IF(AND(H31=H33,H31="y es"),(H31-18148)*0.1+(E33-18148)*0.1)

h31 = income
h33 =income

e31 = yes/no
e33 = yes/no

So if yes is selected in e31 and or e33 i need the formula
(h31-$18,148)*10%. There is also a need to show no result if either
applicants income is less than $18,142. Of course only one applicant
may have
a student loan and the other may not. So i need the formula to populate
the
object cell with nothing if neither applicants have a student loan, the
answer if 1 applicant has a student loan but the other does not or add
the
answer together if both have a student loan.

Can you see where i have gone wrong in my attempt?
--
Thanks in advance.

Scoober