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!!!

Claus B,
Perhaps I need to explain further.
Days on Hand range is <30 , <35 , <45 and <55
Score is: if within the range 35 pts
if 1-5 days over range 25 pts
if 6-9 days over range 15 pts
if 10 days or more over range 0 pts
It looks like I need an and if function but have not had luck writing one that works
you are most kind to assist.

Hi David,

Am Wed, 15 Oct 2014 18:48:20 +0100 schrieb Davidgberg:

Perhaps I need to explain further.

you are in the wrong thread.
What about the posted formula?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional