LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 130
Default Ron and/or Excelent replies on combining and/or

Thanks for the quick response but Im not getting the correct result

{=AND(OR(G59=K59:N59),OR(H59=K59:N59),1,0)}

The value still comes up false yet the result should prove true. G59 is the
first cell.

7431 478641 FALSE

I was given six numbers and then was given 4. I need to represent a 1 if
both of the first two numbers in the four number group ( 7 and 4 ) are found
in the first four numbers ( 4,7,8,6 ) of the six number group ( 478641).

Thanks again!


 
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
Can excel have a button to input (stamp) the systems date and/or . abe Excel Worksheet Functions 5 April 24th 07 10:00 PM
Combining data from two columns PCLIVE Excel Discussion (Misc queries) 0 August 2nd 06 08:10 PM
VBA to concatenate Text and/or Numbers and/or dates etc [email protected] Excel Discussion (Misc queries) 2 July 25th 06 02:46 AM
Combining AND/OR in an IF statement dread Excel Worksheet Functions 4 July 20th 06 06:05 PM


All times are GMT +1. The time now is 12:31 AM.

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

About Us

"It's about Microsoft Excel"