I'm not sure if this is the right forum, but here goes:
I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null.
I just keep getting an error, because of self-reference (E8).
("HVIS" translates to "IF")
I also thought about changing the textcolor using conditional formatting, but it seems that it's not possible to do that using other cells as the conditional factor by itself. It is however possible, if the cell value is compared to another cell, but i wouldn't know how to use that to achieve my goal.
Does anyone knows how to achieve this, without using AppleAcript?
I need the spreadsheet to be compatible with iOS as well, which is why AppleScript is not an option.
EDIT: I figured out a way around it by using conditional formatting.
I made the text change to white (same as background), if the value is greater than G8. G8 already has a function that changes the value to 0, if the checkbox is checked.
Best Answer
If I understand your question:
Instead of referencing itself, reference the formula that created the amount.
So, E8 appears to be
B8-F8, correct? Then the formula for E8 can be:This will return Null or empty string without the self-reference error.
Screenshot is using Numbers 3.6.1 US edition but the formulas should work if adjusted for your localized version: