LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Benny
 
Posts: n/a
Default Help with creating Formula again

Need help with the following 2 situations involving data contained in 2 fields
to create a €œYes€ or €œNo€ field according to the following:

Situation #1

IF cell D2={1,2,3,4} and cell R2=1 then =€Yes€
And also if cell D2={1,2} and cell R2=0 then is also = €œYes€

Situation #2

Cell D2={5,7} and cell R2={0,1} then = €œNo€

--
Benny
 
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
Creating an EXCEL COUNTIF formula for a range of values Pat Walsh Excel Discussion (Misc queries) 5 January 21st 05 02:57 PM
Creating Formula using check boxes Anthony Slater Excel Discussion (Misc queries) 3 January 4th 05 03:03 PM
HELP creating what should be easy formula! dmeals Excel Worksheet Functions 1 January 3rd 05 12:21 AM
HELP creating formula! dmeals Excel Worksheet Functions 0 January 2nd 05 11:39 PM
Creating a formula that references other sheets WisconsinMike Excel Worksheet Functions 1 December 29th 04 05:50 PM


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