Thread: How do i set the value "TRUE" as "YES" in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default How do i set the value "TRUE" as "YES" in excel
Paste this into B1 and type True into A1
=IF(A1="TRUE","Yes","No"

"Rajesh" wrote:

HELP me convert the result of the formula value "TRUE" As "YES" in Excel
Reply With QuoteReply With Quote