Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

Splitting a Cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
williamr - 12 Jun 2007 23:38 GMT
Can a cell be split so you can put 2 pieces of information in it, like
Pass/Fail?
Thanks
Teethless mama - 12 Jun 2007 23:46 GMT
Nope,

> Can a cell be split so you can put 2 pieces of information in it, like
> Pass/Fail?
> Thanks
FSt1 - 13 Jun 2007 01:30 GMT
hi,
in a way you can. you can put a formula in like this...
=if(condition, true, false) or =if(condition, "Pass", "Fail")
if the condition were true then Pass would be displayed in the cell
otherwize if the condition were false then Fail would be displayed in the
cell.
but you would have to be a bit more specific about why you would want 2
pieces of data in the a cell before i can be more specific.

Regards
FSt1

> Can a cell be split so you can put 2 pieces of information in it, like
> Pass/Fail?
> Thanks
 
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.