Excel formula not working right

Closed
CatFox - Jun 27, 2012 at 11:02 AM
TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 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 reply

TrowaD
Posts
2888
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 16, 2022
515
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