# Formula to add 1 with IF statement

Solved/Closed
edmaclod
Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015
- Dec 8, 2015 at 09:26 AM
edmaclod
Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015
- Dec 8, 2015 at 11:57 AM
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!

Thanks

Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Dec 8, 2015 at 11:25 AM
Hi Edmaclod,

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

Best regards,
Trowa
edmaclod
Posts
2
Registration date
Tuesday December 8, 2015
Status
Member
Last seen
December 8, 2015

Dec 8, 2015 at 11:57 AM
Thank you so much! That did it :-)