Excel formula not working right

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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 28, 2012 at 09:37 AM
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
0