Solved Trouble with if(and(or statement

June 27, 2018 at 19:23:45
Specs: Windows 7
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 user

15	I	J
16 Fam Size     income limit
17	2	78700
18	4	90505

This 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


See More: Trouble with if(and(or statement

Report •

#1
June 27, 2018 at 19:36:45
✔ Best Answer
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


Report •
Related Solutions


Ask Question