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

edmaclod 2 Posts Tuesday December 8, 2015Registration date December 8, 2015 Last seen - Dec 8, 2015 at 09:26 AM - Latest reply: edmaclod 2 Posts Tuesday December 8, 2015Registration date December 8, 2015 Last seen
- 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
See more 

2 replies

Best answer
TrowaD 2396 Posts Sunday September 12, 2010Registration dateModeratorStatus July 19, 2018 Last seen - Dec 8, 2015 at 11:25 AM
2
Thank you
Hi Edmaclod,

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

Best regards,
Trowa

Thank you, TrowaD 2

Something to say? Add comment

CCM has helped 1662 users this month

edmaclod 2 Posts Tuesday December 8, 2015Registration date December 8, 2015 Last seen - Dec 8, 2015 at 11:57 AM
Thank you so much! That did it :-)