My LibreOffice Calc spreadsheet contains the following formula:
=IF(D8=0,'',C8*D8/B8)If B8, C8, and D8 all have values, then this works. But if they are empty it doesn't work, I get a #NAME? error code.
In this particular case, all I want is a version of the formula that works for empty and full input cells (I think you can see the intent), but I would also like, in the general case, to interrogate LibreOffice and ask it which part of the formula contains an invalid name reference.
Can I do this?
1 Answer
Part 1: Formula that works for empty cells
Use double quotes: =IF(D8=0,"",C8*D8/B8)
A text string in LibreOffice Calc (and Microsoft Excel) is specified with double quotes. The #NAME? error in your formula is from trying to display '' which is an invalid identifier or value.
- The formula
=''results in a#NAME?error. - The formula
=""displays a blank cell.
Part 2: Determine Invalid Part Of Formula
Click the Function Wizard icon () to open the Function Wizard for the cell.
In this case, the error is indicated by the red circle on the '' line.
