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

Question

Ask a question Report

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

Excel Ask a question Report

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

2 replies

Ask a question

Accepted Answer

Best answer

Report Respond to TrowaD

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

Report

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 :-)

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

Your reply