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
by t quinn,Solvedanswer
Mac OS X
Hi Tim Blaney,
You can get the result with an additional column. You can't have a cell that holds both entered data and a formula.
quinn
Posted on Nov 2, 2015 1:51 PM

