I have a custom function provides results based on user input - once of these variables accepts either Numerical or Percentage, which provides the data as standard number, or a percentage of the total.I've tried looking at conditional formatting to change the number format based on the value of the above variable's cell, but wasn't successful.  Is this possible in Google Sheets?  Is there some kind of workaround?
Conditional number format (whole number, percentage) based on the value in another cell
google spreadsheets;conditional formatting