ExcelBanter - Join two functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Join two functions (https://www.excelbanter.com/excel-worksheet-functions/451457-join-two-functions.html)

b_nuruddin

Join two functions

I have two if(and(or statements that work separately but cant figure out how to join them together into one. Is there a way to join or re-write the following to statements as one?

Statement 1
=IF(AND(OR($H:$H="Hard Advanced",$H:$H="Hard Standard"),$O:$O<= 10),"Met","Not Met")

Statement 2
=IF(AND(OR($H:$H="Soft Advanced",$H:$H="Soft Standard"),$O:$O<= 5),"Met","Not Met")

Please help.

Thanks

Claus Busch

Join two functions

Hi,

Am Fri, 27 May 2016 16:34:17 +0100 schrieb b_nuruddin:

Statement 1
=IF(AND(OR($H:$H="Hard Advanced",$H:$H="Hard Standard"),$O:$O<=
10),"Met","Not Met")

Statement 2
=IF(AND(OR($H:$H="Soft Advanced",$H:$H="Soft Standard"),$O:$O<=
5),"Met","Not Met")

try in row 1:
=IF(OR(AND(LEFT(H1,4)="Hard",O1<=10),AND(LEFT(H1,4 )="Soft",O1<=5)),"Met","Not Met")
ans copy down.

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

b_nuruddin

Quote:

Originally Posted by Claus Busch (Post 1623604)

Hi,

=IF(AND(OR($H:$H="Hard Advanced",$H:$H="Hard Standard"),$O:$O<=
10),"Met","Not Met")

Statement 2
=IF(AND(OR($H:$H="Soft Advanced",$H:$H="Soft Standard"),$O:$O<=
5),"Met","Not Met")[/i][/color]

try in row 1:
=IF(OR(AND(LEFT(H1,4)="Hard",O1<=10),AND(LEFT(H1,4 )="Soft",O1<=5)),"Met","Not Met")

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi Claus B.

Solution worked like a charm.
Thanks for the speedy reply.

Regards,
Nuruddin

All times are GMT +1. The time now is 03:35 AM.