Formula to add 1 with IF statement [Solved/Closed]

Report
Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015
-
Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015
-
Hi,
Here's the breakdown of what I'm trying to do:

The formula is going in cell 'Y28' and I'm attempting to do two different things:

1) I want cell 'Y28' to equal the number in 'T28' if both cells 'R29' and 'R30' are a "W"
2) If R29 or R30 have an "L", I want Y28 to be the number in T28+1.

So basically, if 'T28' is the number 1 and both R29 and R30 are "W", than I want Y28 to be a 1. But if either R29 or R30 are an "L", I want Y28 to be a 2.

Here's the formula I have so far.

=T28*(IF(R29="W",AND(R30="W")))

This works for the first (1) part above and I've tried several other types of formulas to accomplish the second (2) part with no luck!

Please help :-)

Thanks

1 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
Hi Edmaclod,

Try this formula:
=IF(AND(R29="W",R30="W"),T28,IF(OR(R29="L",R30="L"),T28+1,""))

Best regards,
Trowa
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015

Thank you so much! That did it :-)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!