Custom Formats In Excel 1

[jmrdaddy]

I need to format cells so that the value "TRUE" gives a "1" and value "FALSE" gives a "0".

I've figured out how to do it the opposite...

[=1]"TRUE";[=0]"FALSE";General

but I can't get what I want to work. Can someone help, please?

 

[SkipVought]

Hi,

=IF(A1=TRUE,1,0)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

and, actually, it could be written...

=IF(A1,1,0)

;-)

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jmrdaddy]

=IF(A1,1,0)

This works if you want to put that equation in another cell.

So that you don't have to deal with another equation, is there a way to use custom formats to do it?

Or am I misunderstanding. This equation can be used in custom formats and I'm just not doing correctly.

 

[SkipVought]

What do you want to happen. If you return a value to the cell that you are evaluating, you get a circular reference.

However, you could use a Conditional Format and shade the cells in question if they test true or false using

Formula Is =A1 and shade green, for instance

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xlbo]

Why do you need this ???
If you need it for a formula then simply multiplying TRUE by 1 will give a 1 and multiplying FALSE by 1 gives 0 so if it is for calc use, don't bother, just include a cell*1 step in the calc....

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[jmrdaddy]

Thanks. I guess I was looking at this incorrectly. That is much simpler.