Works fine for numbers 0 and 1 but not for TRUE/FALSE. Anyway, thanks a lot,
I'll work around it. Na eisai kala!

"Gary Keramidas" wrote:

if the result is 0, you will see error in the cell, if it is one, you will
see OK, if it's neither you will just see whatever is supposed to be in the
cell

[=1]"Ok";[=0]"Error";General

--


Gary


"DoctorG" wrote in message
...
I've tried it and it doesn't work for me. If you have done it and it works
pls post your format.

"Gary Keramidas" wrote:

use 1 and zero instead of true and false

--


Gary


"DoctorG" wrote in message
...
I read the answer to a previous post on advanced formatting but I
couldn't
get it to work in my case.

I would like to display "OK" or "ERROR" in a field with a logical
expression
resulting in TRUE/FALSE.
How should this change ?...[<1]0" Children";[=0]0" Child";General
I tried [=TRUE] "OK";[=FALSE] "ERROR";0 but it didn't work

Please note that I cannot use General due to regional settings