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!

Please help :-)

Thanks
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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
2
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 :-)
0