Custom Boolean Values in Microsoft Excel

[Thedevotee]

I need to display boolean worksheet values not as TRUE or FALSE, but as "Y" and "N" without the use of conditional formatting, macros or functions; a custom format. The custom format: "Y";;"N"; works if the field value is numeric, but not for boolean expressions or values.

[Essien]

Not possible unless you change the function that returns the TRUE or FALSE like if you have =A2>5 change that to =--(A2>5) then use your custom format "Y";;"N".

[GaganjyotTechie]

I am rightnow working on Boolean additions. Where Why {= SUM (A1: A4 = 1)} gives 0 while {= SUM ((A1: A4 = 1) * 1)} gives the expected result. And when the two meet Laurent exactly at the same time it gives this: The Sum function accepts numerical parameters, boolean or text without flinching, but that does not mean that it takes into account.