mardi 25 juin 2019

Google Sheets equation that doesn't go below zero

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