# If a cell contains any text then add a value

Solved
Related:

- If a cell has text then return value
- If cell contains specific text then return value in another cell - Best answers
- If cell has text then return value - 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 contains text then return value multiple conditions ✓ - 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))