Hello all, I'm attempting to require comments in column g for
variances in column d. These conditions would require coments.... if
d6 is is greater than or equal to 10% of b6, and greater than or equal
to 10,000, and if b6 equals 0 and c6 is greater than or equal to
10,000.

I would like to populate column G with "COMMENTS REQUIRED" or, "",
when the conditions above are met instead of False, #Div/0!, or True
that I get with the formula below.

=IF((D6/B6)=10%,AND(D6=10000))=IF((D6/
B6)<=-10%,AND(D6<=-10000))=IF(B6=0,AND(C610000))

1,920 995 (926) -93.1% FALSE
- 6,785 6,785 100.0% #DIV/0!
6,201 258 (5,943) -2307.6% FALSE
16,670 52 (16,618) -32087.3% TRUE


Thank you for your assistance,
Ron