Formula to add 1 with IF statement
Solved/Closed
edmaclod
edmaclod
- Posts
- 2
- Registration date
- Tuesday December 8, 2015
- Status
- Member
- Last seen
- December 8, 2015
edmaclod
- Posts
- 2
- Registration date
- Tuesday December 8, 2015
- Status
- Member
- Last seen
- December 8, 2015
Related:
- Formula to add 1 with IF statement
- How to use an IF statement to add 1 to total - Guide
- Excel formula add 1 if cell contains text ✓ - Forum - Excel
- Excel if cell contains date then add 1 ✓ - Forum - Office Software
- Jio Adds 1,000 Subscribers Per Minute - News
- Formula to add 90 days to a date - Guide
1 reply
TrowaD
Dec 8, 2015 at 11:25 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Try this formula:
=IF(AND(R29="W",R30="W"),T28,IF(OR(R29="L",R30="L"),T28+1,""))
Best regards,
Trowa
Dec 8, 2015 at 11:57 AM