If a cell contains any text then add a value
Solved
Related:
- If cell contains text then return value in another cell
- Google sheets if cell contains text then return value in another cell - Best answers
- If cell contains specific text then return value in another cell - Best answers
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
2 replies
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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))