Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default 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
  #3   Report Post  
Junior Member
 
Posts: 4
Thumbs up

Quote:
Originally Posted by Claus Busch View Post
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Join two functions to one column Greg Excel Programming 2 October 31st 09 04:19 PM
Join tables like inner join in Access ryanp Excel Discussion (Misc queries) 2 July 18th 08 03:35 PM
SQL + INNER JOIN + ADO Oscar K Excel Programming 0 June 5th 08 12:55 PM
How to join two functions in a formula? Suzanne Excel Worksheet Functions 1 March 29th 07 01:48 PM


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"