I need help to figure this out

Copper Contributor

what's wrong with this formula = IF (B9> 0), "QUOTIENT (B9, G9)" ??

2 Replies

@Oscarcasadiego 

 

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)  

@Oscarcasadiego 

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).