Related:

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

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

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