Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
HELP creating what should be easy formula! | Excel Worksheet Functions | |||
HELP creating formula! | Excel Worksheet Functions | |||
Creating a formula that references other sheets | Excel Worksheet Functions |