# If a cell contains any text then add a value

Solved
Related:

- Excel formula if cell contains text then return value in another cell
- If cell contains text then return value in another cell - Best answers
- Excel if cell contains text then return value in another cell - Best answers
- Excel formula if cell contains date then return date in another cell ✓ - Forum - Office Software
- Excel: If Date =, then enter a value ✓ - Forum - Excel
- Excel if range of cell contain a text put a cell value in ✓ - Forum - Excel
- If a cell contains any text then add a value (with dates) ✓ - Forum - Excel
- If cell A1 has text then cell B2 has today's Date ✓ - Forum - Excel

## 2 replies

venkat1926

Updated on Nov 27, 2018 at 04:13 AM

- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021

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

Feb 25, 2014 at 09:13 AM

May 19, 2014 at 12:06 PM

Oct 1, 2014 at 09:53 PM