Display TRUE as C

[Trebor777]

Hi. I have a column of cells (say column J) that return a logical TRUE or FALSE, and display TRUE or FALSE accordingly. I would like to display C or zero instead.

I know how to do this using an IF , applied to the logical expression concerned. The problem is that the logical expression in J is very complex (developed with your help), and I don't want to make it any longer.

One option would be to create a new column, with an IF inside it to test the column J and return C or zero. Then hide column J.

Any simpler ideas ?

Thanks as always

K

[Tony Valko]

the logical expression in J is very complex (developed with your help), and I don't want to make it any longer.

One option would be to create a new column, with an IF inside it to test the column J and return C or zero. Then hide column J.

Any simpler ideas ?

Well, if you don't want to make the original formula any longer then the new column is about your only other option.

[Richard Buttrey]

Hi

Please Login or Register  to view this content.

But why not just wrap your long formula inside an IF and avoid an additional column. You're only extending the formula by 4 characters.

Please Login or Register  to view this content.

[shg]

If you relented to using 1 and 0 versus C and 0, you could use

=--(your formula)

[Trebor777]

Hi and thanks all for the ideas. As I expected there is no magic solution. I suspect the 1,0 route might be simplest. K

[shg]

You're welcome.