Menu
Ask a question Report

If a cell contains any text then add a value [Solved/Closed]

-
Excel Ask a question Report
I hope someone can help me with this...I've done this before but can't remember how.

I have a list of names (for an attendees list) and I need to show an extended total for each
person and the number of guests they will bring. Here's the layout...

B2 is the person's name
C2 is the number of guests they will bring
D2 is the total for that person (including them)

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.

Hope that makes sense. Thank you in advance for helping.
See more 

2 replies

Best answer
approved by Jean-François Pillou on Nov 29, 2018
Report
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 776
84
Thank you
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,"")

Say "Thank you" 84

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 6686 users have said thank you to us this month

View all 17 comments
Report
-
Thanks
Report
-
Thank you bro
Report
-
Exactly what I was looking for thank you.
Report
-
thanks uuuu
Report Respond to Pharmanumbers
-
Thanks - Solved a tricky little issue in a spreadsheet populated with numbers and text.
Report
1
Thank you
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"}),"")
Report
-
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"
Ask a question