Excel formula not working right

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I am trying to write a formula for the following situation and for some reason anything I come up with is not working properly:

if R2="Benefit Type X", AND D2="Group Name X","do not use the paragraph" all other groups would not use the sentence either it is a specific group and benefit type that would insert the sentence.

Any help would be greatly appreciated, using 2010

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Catfox,

I'm not sure if this is what you are looking for, if it's not, then please explain in greater detal.

=IF(AND(R2="Benefit Type X",D2="Group Name X"),"do not use the paragraph","")

Best regards,
Trowa