Tim Blaney

Q: if function reference it's own cell

I'm using Numbers on iPad.  I want to create an IF function for a cell but get the error, "Function cannot reference it's own cell.."

 

Here's what I'm trying to do:

 

In cell A1 I want to create a function that says if cell A1 contains the text "paid" then I want to add 0 to the total in cell B1.  If cell A1 is blank, then I want to add 15 to the total in cell B1.

 

Right now I have the formula:

 

If (A1="paid",B1+0, B1+15)

 

What am I doing wrong???

Mac OS X (10.4.1)

Posted on Nov 1, 2015 7:19 PM

Close

Q: if function reference it's own cell

  • All replies
  • Helpful answers