 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 20073 cell problem
Hi need help with this simple task. 3 cells A1 A2 & A3, if cell a2 has the number 1 in it I need cell A1 to display yes, if cell a3 has the number 1 in it I need cell A1 to display no, If both cells are blank I need A1 to be blank. Thanks Much... Diane maybe... =if(a2=1,"yes",if(a3=1,"no",if(and(a2="",a3=""),"","what goes here"))) What happens if both a2 and a3 contain 1? What happens if A2 or A3 are not blank, but don't contain 1? > Hi need help with this simple task. > 3 cells A1 A2 & A3, [quoted text clipped - 4 lines] > Thanks Much... > Diane  SignatureDave Peterson Hi & Thanks When both cells A2 & A3 are blank A1 stays blank. Only 1 cell A2 or A3 will have the number 1 in it. Thanks dave >maybe... > [quoted text clipped - 12 lines] >> Thanks Much... >> Diane Thanks Dave, worked great... Diane "Di" >maybe... > [quoted text clipped - 12 lines] >> Thanks Much... >> Diane
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.