ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Splitting a Cell (https://www.excelbanter.com/excel-worksheet-functions/146255-splitting-cell.html)

williamr

Splitting a Cell
 
Can a cell be split so you can put 2 pieces of information in it, like
Pass/Fail?
Thanks

Teethless mama

Splitting a Cell
 
Nope,

"williamr" wrote:

Can a cell be split so you can put 2 pieces of information in it, like
Pass/Fail?
Thanks


FSt1

Splitting a Cell
 
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

"williamr" wrote:

Can a cell be split so you can put 2 pieces of information in it, like
Pass/Fail?
Thanks



All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com