- If a cell contains any text then add a value
- Excel if cell contains any value
- Excel create cell wich contains value of other cells as a string
- If a cell contains any text then add a value (with dates) [Solved] (Solved)
- Excel - Using IF statement to add 1 to total
- If cell contains certain text, add certain text in cell adjacent
- Highlight cell if another cell contains any text (Solved)
- How to use conditional format based on text [Solved] (Solved)

quote

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.

quote

why not just the condition that if B2 is not blank

then D2 will have

if you insist on condition that if B2 is text then the fomula in D2 is

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.

quote

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

Was this answer helpful?

I need a formula that says:

If cell contains any date for cell1- Pick up date or cell2- Delivery date then it is "served" if none "pending"

Reply
If cell contains any date for cell1- Pick up date or cell2- Delivery date then it is "served" if none "pending"

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Huwbacca- Oct 30, 2015 at 05:15 AMlogic statements will return 1 if string is present or 0 if the cell is empty.

P- Jan 14, 2016 at 03:52 AMRupak- Jan 23, 2016 at 01:31 AMKillajdotwizzle- Feb 23, 2017 at 10:06 AMfor example

You use =IF(ISTEXT(B1), 1,"")

Abby- Jul 3, 2017 at 08:31 PM