Hi. I have what is probably a simple problem, but cannot figure out how to fix.

I have an @IF() formula in a formula that looks like this....

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.

Things I have tried to fix....

1. I have tried changing from general to number in the format cells option but still I get the word FALSE.

2. Went to the microsoft office icon, excel options,advanced and scrolled down to "display options for this worksheet" - only to find that the box that says "show a zero in cells that have zero value" is already checked.

Can anyone help me get rid of the FALSE word and have an actual number zero in this cell?

Many thanks in advance.

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

On Wednesday, 15 October 2014 08:00:29 UTC+5:30, rdjohnsons wrote:
Hi. I have what is probably a simple problem, but cannot figure out how
to fix.

I have an @IF() formula in a formula that looks like this....

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.

Things I have tried to fix....

1. I have tried changing from general to number in the format cells
option but still I get the word FALSE.

2. Went to the microsoft office icon, excel options,advanced and
scrolled down to "display options for this worksheet" - only to find
that the box that says "show a zero in cells that have zero value" is
already checked.

Can anyone help me get rid of the FALSE word and have an actual number
zero in this cell?

Many thanks in advance.




--
rdjohnsons


Dear Try this.


=IF(h9="Value",0,h9)