Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07: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 11:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us