IF function

  • Thread starter Thread starter BOB
  • Start date Start date
B

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").
 
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
 
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
 
Back
Top