View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Advanced Formatting [2]

There is no formatting for True or False
Modify the logical expression

=if(logicalexpression=true,"OK","ERROR")
--
Regards,
Tom Ogilvy

"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