IF function

[BOB]

What is wrong with this IF function? I have a hidden column
(column K), in one of the cells I am trying to calculate
if a total dollar amount in column N(not hidden), if that
value is equal to $0.00. Then another cell in column J(not
hidden) is equal to another cell in column C (not hidden).
My statement is as follows: =IF(N56="0",J57=C57,j57="0").

 

[Sandy Mann]

Bob,

Functions can only return values to the cell that the function is in - it
can't alter any other cell. You therefore have to enter the formula in cell
J57. Also you don't need the quotations around the zeros, so your formula
becomes:

=IF(N56=0,C57,0)

HTH

Sandy

 

[Charlie]

Bob,

What is the end result you are look for?
There are several ways to write the IF statement. It can
be nested with AND, OR functions for example.
=IF(OR(N56="0",J57=C57,J57="0"),desired results,"")
In the above if any of the conditions are TRUE then the
reference to the 'desired results' will be displayed. If
all are FALSE then nothing is displayed.

Charlie O'Neill

 

[Sue Harsevoort]

Don't put the quotes around the 0. You only need the quotes for text
values.

Sue

 

[Guest]

Bob,

OOPS!!!

I misunderstood the queston. See Sandy's reply.

Charlie O'Neill