I have an equation that looks like this in Google Sheets:
= (x - 500) ^ 0.38
The problem is that any value of x under 500 results in a cell value of #NUM! since zero to the power of 0.38 is not a real number.
How can I modify this equation so that instead of showing #NUM! it just shows 0 when x < 500?
Aucun commentaire:
Enregistrer un commentaire