If a cell contains any text then add a value
Solved
Related:
- If a cell has text then return value
- If cell has text then return value - Best answers
- Excel if cell contains any text then add 1 - Best answers
- If cell contains date then return value ✓ - Office Software Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Excel formula to check if cell contains a date - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Updated on Nov 27, 2018 at 04:13 AM
Updated on Nov 27, 2018 at 04:13 AM
I need a formula that says: If B2 has any text, then add a value of "1" to C2 and enter the total in D2.
why not just the condition that if B2 is not blank
then D2 will have
=if(B2<>"",c2+1,"")
if you insist on condition that if B2 is text then the fomula in D2 is
=if(istext(B2),c2+1,"")
Mar 18, 2013 at 09:01 AM
If there is no Attendee, then there is no guests.. so C2 is always '+1'
Mar 18, 2013 at 02:16 PM
=IF(B2="","",(1+C2))