Not sure I understand the problem.
See the values of :
=True*True*100
=False*True*100
=False*False*100

NickHK

"kayard" wrote in
message ...

thanks, but I actually have to make it even harder.

Let's make this example. I have column A containing either true or
false


--
kayard
------------------------------------------------------------------------
kayard's Profile:
http://www.excelforum.com/member.php...o&userid=24716
View this thread: http://www.excelforum.com/showthread...hreadid=569507