# Formula to add 1 with IF statement

[Solved/Closed]
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!

Thanks

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Hi Edmaclod,

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

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

Thank you so much! That did it :-)