Apr 18 2020 01:19 PM
what's wrong with this formula = IF (B9> 0), "QUOTIENT (B9, G9)" ??
Apr 18 2020 02:22 PM
Assuming that where B9 is greater than zero, you want the text result 'QUOTIENT (B9, G9)', you simply have a closed parentheses in the wrong place. For good order, you should also include a result if the logical test is false (i.e. B9 is equal to or less than zero) - try this:
=IF(B9>0,"QUOTIENT (B9, G9)",FALSE)
Apr 19 2020 04:04 AM
In addition, quotes are not needed.
As variant that could be also
=IFERROR(MAX(0,QUOTIENT(B9,G9)),0)
which returns zero for negative B9 and if divide on zero (G9).