LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Is It False ??

In A1 thru A4 I have:

1
=
2

In A5 I have:

=A1 & A2 & A3 & A4
which displays =1=2

Is there any way I can evaluate this (should be False) without using VBA ?

--
Gary''s Student - gsnu2007xx
 
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
Why is E3=4 FALSE? johnthebaptist Excel Worksheet Functions 12 November 14th 07 01:43 PM
FALSE value Keyrookie Excel Worksheet Functions 4 September 18th 07 08:29 PM
0 instead of false Jaleel Excel Discussion (Misc queries) 17 December 10th 06 09:30 PM
$C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # Steved Excel Worksheet Functions 6 July 3rd 06 01:49 AM
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? bchilt Excel Worksheet Functions 6 January 20th 06 09:21 AM


All times are GMT +1. The time now is 04:05 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"