View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default Display TRUE / FALSE Instead Of 1 / 0

hi exceluser

for an IF formula
maybe like this
=if(1=1,1,0) then replace it with
=if(1=1,TRUE,FALSE)

regards
--
*****
birds of the same feather flock together..



"ExcelUser123" wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?