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