Excel formula not working right

Closed
CatFox - 27 Jun 2012 à 11:02
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 28 Jun 2012 à 09:37
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

Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Jun 2012 à 09:37
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