View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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