# If a cell contains any text then add a value

Solved
Related:

- If cell contains specific text then return value in another cell
- Excel formula if cell contains text then return value in another cell - Best answers
- If a cell has text then return value - Best answers
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Highlight cell if another cell contains specific text - Excel Forum
- Count if cell contains number - 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))