LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Portuga
 
Posts: n/a
Default If Statement - Help Needed


A1 B1 C1 D1
A2 B2 C2 D2
A3 B3 C3 D3

How can I do the following in A1, A2, A3:

If B1 _AND_ B2 _AND__B3 are Blank the A1=YES.
IF B1 _OR_ B2 _OR_ B3 have any values then A1= NO

Thanks!


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=504504

 
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
IF STATEMENT HELP NEEDED!!! Excel Dummy Excel Discussion (Misc queries) 2 December 30th 05 07:02 PM
help needed with "if" statement gina_b Excel Worksheet Functions 2 December 30th 05 04:24 PM
If Then statement help needed jmcclain Excel Worksheet Functions 2 January 10th 05 08:52 PM
If Statement help needed please Ian Harris Excel Worksheet Functions 3 December 3rd 04 02:04 PM
If statement needed Patsy Excel Worksheet Functions 1 November 4th 04 03:48 PM


All times are GMT +1. The time now is 08:07 PM.

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"