If a cell contains any text then add a value
Solved
Related:
- Excel add 1 if cell contains text
- If a cell has text then return value - Best answers
- Excel if cell contains any text - Best answers
- Tentacle locker 1 - Download - Adult games
- Fnaf 1 download pc - Download - Horror
- Igi 1 download - Download - Shooters
- Fnia 1 apk - Download - Adult games
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
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))