Related:

- Google sheets if cell contains any text then
- Excel formula 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
- Google sheets move row to another sheet based on cell value ✓ - 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

## 2 replies

venkat1926

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

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