[Solved] Combining 2 IF(AND) tests

[michaelz7]

hello,

I have read what I could find online and in other answers in this fine forum but need to ask for help.

I would like to combine the following 2 IF(and) tests looking for return of TRUE if either is true.

=IF(AND(J9=1);(F9+G9+H9>45000))

=IF(AND(J9=2);(F9+G9+H9>30000))

I've read some answers on this site from very talented and experienced folks. I hope my goal is doable. Have tried many iterations but without success.
Thank You.
michael

[robleyd]

Seems like you need an OR to select if either AND is TRUE; maybe something like

Code: Select all

=IF( OR ( AND ( J9=1 ; F9+G9+H9>45000 ) ; AND ( J9=2 ; F9+G9+H9>30000 ) ) ; 1; 0)

Substitute whatever you need for 1 - TRUE and 0 - FALSE

[michaelz7]

That works perfectly David. Thank you very much.

I love OpenOffice. Thank you Apache. So glad to not use Gatesware.

Again, David I appreciate the very quick reply to my question, and elegant solution of yours.

Good night, from frosty Oshkosh, WI USA.

[MrProgrammer]

Hi, and welcome to the forum.

I would like to combine the following 2 IF(and) tests looking for return of TRUE if either is true.
=IF(AND(J9=1);(F9+G9+H9>45000))
=IF(AND(J9=2);(F9+G9+H9>30000))

=SUMPRODUCT(J9={1|2};F9+G9+H9>{45000|30000})

[Tutorial] The SUMPRODUCT function

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[michaelz7]

I do enjoy the power of spreadsheets. It has been a several years since I tried anything to tap into the power, and much of the learning curve I'd climbed has faded without frequent use.

I see you're enjoying your workhorse as I am. My computer experience began in Chicago with Chicago MUG (TROU) in mid 1980s.

Thank you Dr. Programmer. Always interesting to see that there is more than one successful way to navigate thru the maze.

I'll try tomorrow. I am excited to learn. My spreadsheet use is for volunteer work. I enjoy being a blessing where I can, and I appreciate those who do the same.


g'nite Dr. P