Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
logic statement
Hope someone can help, as i am not too good at functions (Is there a book
with examples in??) i would like to know a statement that will allow 1 answer cell to have two conditions from two seperate work books. if 1 work book cell is eg "OK" then one answer would be "N" if the other work book cell was "y" then the answer would be "Y" Only one cell either OK or Y would be populated. the other would be blank. Regards Andy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
logic statement
1. For you first question refer HELP on functions; or refer the below site
http://www.excelfunctions.net/ 2. Use the IF condition =IF(A1="OK","Y","N") OR =IF(A1="OK","Y",IF(A1="Y","N","")) If this post helps click Yes --------------- Jacob Skaria "andy" wrote: Hope someone can help, as i am not too good at functions (Is there a book with examples in??) i would like to know a statement that will allow 1 answer cell to have two conditions from two seperate work books. if 1 work book cell is eg "OK" then one answer would be "N" if the other work book cell was "y" then the answer would be "Y" Only one cell either OK or Y would be populated. the other would be blank. Regards Andy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
logic statement
With your condition
if 1 work book cell is eg "OK" then one answer would be "N" if the other work book cell was "y" then the answer would be "Y" the formula would be =IF(A1="OK","N",IF(A1="Y","Y","")) of if you need to return whatever in A1 then use =IF(A1="OK","N",A1) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: 1. For you first question refer HELP on functions; or refer the below site http://www.excelfunctions.net/ 2. Use the IF condition =IF(A1="OK","Y","N") OR =IF(A1="OK","Y",IF(A1="Y","N","")) If this post helps click Yes --------------- Jacob Skaria "andy" wrote: Hope someone can help, as i am not too good at functions (Is there a book with examples in??) i would like to know a statement that will allow 1 answer cell to have two conditions from two seperate work books. if 1 work book cell is eg "OK" then one answer would be "N" if the other work book cell was "y" then the answer would be "Y" Only one cell either OK or Y would be populated. the other would be blank. Regards Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logic Statement | Excel Discussion (Misc queries) | |||
Need help w/ logic statement in excel | Excel Worksheet Functions | |||
rather complex logic statement | Excel Worksheet Functions | |||
Logic Statement | Excel Worksheet Functions | |||
Two Logic tests in an IF Statement | Excel Worksheet Functions |