Need help in getting this formula to return the correct results.

Logic:

if G10<3 (family size test) and F9<J17 (income test) then 15000 otherwise "does not qualify"

OR

if G10>2 (family size test) and F9<J18 (income test) then 15000 otherwise "does not qualify"G10=family size inputted by user

F9=income amount inputted by user15 I J 16 Fam Size income limit 17 2 78700 18 4 90505This is the formula I tried but it is not returning the correct results:

=IF(AND(OR(G10<I17,F9<J17),OR(G10>I17,F9<J18)),15000,"Does not qualify")

message edited by mecerrato

Happy to report I got it working after some trial and error with this formula: =IF(OR(AND(G10<=I17,F9<=J17),AND(G10>I17,F9<=J18)),15000,"Does not qualify")

message edited by mecerrato

Ask Your Question

Weekly Poll

Do you find Google Chrome to be a significant drain on your system resources?

Discuss in The Lounge

Poll History