 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
11-29-2007, 01:46 AM
|
|||
|
|||
|
Re: formula help
Assuming it's either Y or N:
=if(D1=Y,B1,C1) Ross "Bob Bob" <NOeMAILl@mail.com> wrote in message news:jJo3j.64715$cD.27626@pd7urf2no... >I need a formula for cell A1 to show what is in cell B1 when cell D1 has Y > and and shw what is in cell C1 when cell D1 has N. > > Thanks to all > > 
|
|
11-29-2007, 03:03 AM
|
|||
|
|||
|
Re: formula help
Ross has an answer but we need quotes: =if(D1="Y",B1,C1)
If Y and N are not the only possibilities, then =if(D1="Y",B1,IF(D1="N",C1,"")) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Bob Bob" <NOeMAILl@mail.com> wrote in message news:jJo3j.64715$cD.27626@pd7urf2no... >I need a formula for cell A1 to show what is in cell B1 when cell D1 has Y > and and shw what is in cell C1 when cell D1 has N. > > Thanks to all > >
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
