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