IF FUNCTION NOT WORKING PROPERLY
 

IN CELL K46 I HAVE THE FOLLOWING FORMULA
=IF($G$274-SUM($F$258:$J$258)=0,SUM(F46:J46),"DIFF")
IT SHOWS CONDITION AS "TRUE" AND RETURNS RESULT AS 0

IN CELL L46 I HAVE THE FOLLOWING FORMULA :
=IF(K46="DIFF",SUM(F46:J46),"")

HOW CAN THIS CONDITION BE TRUE ?? ( SHOWS CONDITION AS "TRUE" AND RETURNS
RESULT AS 0)

tks in advance

IF FUNCTION NOT WORKING PROPERLY
 

"YESHWANT" wrote in message
...
IN CELL K46 I HAVE THE FOLLOWING FORMULA
=IF($G$274-SUM($F$258:$J$258)=0,SUM(F46:J46),"DIFF")
IT SHOWS CONDITION AS "TRUE" AND RETURNS RESULT AS 0

IN CELL L46 I HAVE THE FOLLOWING FORMULA :
=IF(K46="DIFF",SUM(F46:J46),"")

HOW CAN THIS CONDITION BE TRUE ?? ( SHOWS CONDITION AS "TRUE" AND RETURNS
RESULT AS 0)

tks in advance

IF FUNCTION NOT WORKING PROPERLY
 

"YESHWANT" wrote:
IN CELL K46 I HAVE THE FOLLOWING FORMULA
=IF($G$274-SUM($F$258:$J$258)=0,SUM(F46:J46),"DIFF")
IT SHOWS CONDITION AS "TRUE" AND RETURNS RESULT AS 0

IN CELL L46 I HAVE THE FOLLOWING FORMULA :
=IF(K46="DIFF",SUM(F46:J46),"")

HOW CAN THIS CONDITION BE TRUE ?? ( SHOWS CONDITION AS
"TRUE" AND RETURNS RESULT AS 0)

Any chance that you unintentionally have a custom or conditional format like
;;;"0"?

Thus, if G274 - SUM(F258:J258) is not exactly zero, the result in K46 would
be "DIFF", but the cell format would display the text "0". Then, if
SUM(F46:J46) is about zero, L46 might appear as zero.

Alternatively, if G274 - SUM(F258:J258), K46 might appear as zero if
SUM(F46:J46) is about zero. Then L46 would result in "", but the cell
format would display the text "0".

Of course, another reasonably explanation is: things are not exactly as
they appear in your posting. Did copy-and-paste from the Formula Bar?

Also, how are you determining that the "condition is TRUE" and the cells
"returns result as 0"?

IF FUNCTION NOT WORKING PROPERLY
 

Hi JoeU2004,

I have the same formula for 256 rows and where total for columns F:J is 0,
there only this problem is arising.

IN CELL L46 I HAVE THE FOLLOWING FORMULA :
=IF(K46="DIFF",SUM(F46:J46),"")
If cell k46 = "0", then in any case the above formula is false and should
return "". but in order to check what excel is doing, when i click on "=" or
"fx" button next to formula bar, it shows condition as true and sums F46:J46,
which is 0.

pl note that out of 256 rows this happens in 7 cases only where column F:J
contains 0 only. If any of these column/s contains anything that is 0,
everything is working fine .

any idea ??



"JoeU2004" wrote:

"YESHWANT" wrote:
IN CELL K46 I HAVE THE FOLLOWING FORMULA
=IF($G$274-SUM($F$258:$J$258)=0,SUM(F46:J46),"DIFF")
IT SHOWS CONDITION AS "TRUE" AND RETURNS RESULT AS 0

IN CELL L46 I HAVE THE FOLLOWING FORMULA :
=IF(K46="DIFF",SUM(F46:J46),"")

HOW CAN THIS CONDITION BE TRUE ?? ( SHOWS CONDITION AS
"TRUE" AND RETURNS RESULT AS 0)

Any chance that you unintentionally have a custom or conditional format like
;;;"0"?

Thus, if G274 - SUM(F258:J258) is not exactly zero, the result in K46 would
be "DIFF", but the cell format would display the text "0". Then, if
SUM(F46:J46) is about zero, L46 might appear as zero.

Alternatively, if G274 - SUM(F258:J258), K46 might appear as zero if
SUM(F46:J46) is about zero. Then L46 would result in "", but the cell
format would display the text "0".

Of course, another reasonably explanation is: things are not exactly as
they appear in your posting. Did copy-and-paste from the Formula Bar?

Also, how are you determining that the "condition is TRUE" and the cells
"returns result as 0"?