Related:

- Google sheets if cell contains any text then
- If cell contains any text - Best answers
- Excel if cell contains any text - Best answers
- How to move entire row to another sheet based on cell value in google sheets ✓ - Forum - Excel
- Google sheets copy row to another sheet based on cell value ✓ - Forum - Excel
- Google sheets add rows based on cell value - Forum - Excel
- Google sheets right to left - How-To - Google
- Google sheets drag formula without formatting - Forum - Office Software

venkat1926

- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015

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

View all 17 comments

Report

Abby

Thanks

Report

gggg

Thank you bro

Report

Coqui

Exactly what I was looking for thank you.

Report

bungholejesus

thanks uuuu

Report

Pharmanumbers

Thanks - Solved a tricky little issue in a spreadsheet populated with numbers and text.

jeremylohrentz

I used this formula to return a Day/Night value based on a time value added in an adjacent cell. When no time value is entered in the "C" column, the "G"column cell will display blank.

FORMULA IS ENTERED IN CELL "G1":

=IF(C1<>"",LOOKUP(HOUR(C1),{0;6;18;23},{"Night";"Day";"Night";"Night"}),"")

FORMULA IS ENTERED IN CELL "G1":

=IF(C1<>"",LOOKUP(HOUR(C1),{0;6;18;23},{"Night";"Day";"Night";"Night"}),"")

DON'T MISS

- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- How to Install a VPN
- How to Get More Followers on Instagram
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire