Removing ! (One of the Parameters is Invalid) In Formula Column

Platform discussions Special workflows & use cases
,
1

Hello! I’m having some trouble with the formula I’m working on. I would like the column to return the result “0%” when the columns {(R$) RH} and {(R$) Markup RH} are empty. If the value in the column {(R$) RH} is 1 or greater and the other column is empty, it should return “0%” in the formula. Currently, the message I’m getting is “One of the parameters is invalid.”

IF(
  OR(
    ISBLANK({(R$) RH}),
    ISBLANK({(R$) Markup RH}),
    {(R$) RH} = 0,
    {(R$) Markup RH} = 0
  ),
  "0%",
  TEXT(
    ROUNDUP(
      IF(ISBLANK({(R$) Markup RH}), 0, {(R$) Markup RH}) / 
      IF(ISBLANK({(R$) RH}), 1, {(R$) RH}) * 100,
      0
    ),
    "0"
  ) & "%"
)