Related:

- Google sheets if cell contains any text then
- If cell contains any text - Best answers
- Excel if cell contains any text - Best answers
- Google sheets blinking cell ✓ - Forum - Excel
- Google sheets copy row to another sheet based on cell value ✓ - Forum - Excel
- Copy row to different sheet based on cell ✓ - Forum - Excel
- Copy rows to other sheets based on value in column ✓ - Forum - Excel
- Google sheets add rows based on cell value - Forum - Excel

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