ExcelBanter - How do i set the value "TRUE" as "YES" in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do i set the value "TRUE" as "YES" in excel (https://www.excelbanter.com/excel-programming/387955-how-do-i-set-value-true-yes-excel.html)

Rajesh[_4_]

How do i set the value "TRUE" as "YES" in excel

HELP me convert the result of the formula value "TRUE" As "YES" in Excel

Mike

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

All times are GMT +1. The time now is 02:04 PM.