Quote:
Originally Posted by Claus Busch
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
|
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.