In Google Sheets, I'm using
IMPORTRANGE to pull in data from to a large sheet.
One field is a dollar amount. I would like to import the dollar amount and replace any zero amount with a specific dollar amount. For example, if the number is
$100, I want to import
$100. But if the number is
$0, I want to import it but replace the