Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Help with an Excel formula problem

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Help with an Excel formula problem

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
  #3   Report Post  
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!!!
  #4   Report Post  
Junior Member
 
Posts: 2
Default

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
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.
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Help with an Excel formula problem

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


  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Help with an Excel formula problem

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)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel formula problem gopiganji Excel Discussion (Misc queries) 1 September 3rd 12 07:25 PM
Odd Excel Formula Problem Questions New Users to Excel 1 December 15th 09 08:54 PM
Excel formula problem Oregon Sailor Excel Discussion (Misc queries) 2 April 24th 07 05:10 PM
Problem with formula in Excel Bill R Excel Worksheet Functions 3 August 15th 05 03:02 AM
EXCEL FORMULA PROBLEM detlghtpd Excel Discussion (Misc queries) 1 April 7th 05 12:22 AM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"