View Single Post
  #2   Report Post  
rdjohnsons rdjohnsons is offline
Junior Member
 
Posts: 2
Smile

Quote:
Originally Posted by Claus Busch View Post
Hi,

Am Wed, 15 Oct 2014 03:30:29 +0100 schrieb rdjohnsons:

IF(H9="Value",0)

However, in the cell, when H9 is a value, I am getting the word FALSE
instead of the value of 0.


try:
=IF(H9="Value",0,"")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Well... I knew this was a simple question. This appears to have worked! Thanks very much!!!