If a cell contains any text then add a value

Solved

cbrizz - Updated on Jul 19, 2017 at 05:59 AM
Pharmanumbers - Jun 5, 2019 at 02:02 PM

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.

Excel formula if cell contains text then return value in another cell
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
Excel formula if cell contains date then return date in another cell ✓ - Forum - Office Software
Excel: If Date =, then enter a value ✓ - Forum - Excel
Excel if range of cell contain a text put a cell value in ✓ - Forum - Excel
If a cell contains any text then add a value (with dates) ✓ - Forum - Excel
If cell A1 has text then cell B2 has today's Date ✓ - Forum - Excel

2 replies

Answer 1 / 2

venkat1926

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

810
Updated on Nov 27, 2018 at 04:13 AM

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

Giro
Mar 18, 2013 at 09:01 AM

Slightly complicated considering the subject matter..

If there is no Attendee, then there is no guests.. so C2 is always '+1'

issahamameh

Posts: 22
Registration date: Friday October 19, 2012
Status: Member
Last seen: June 22, 2013

Mar 18, 2013 at 02:16 PM

Please try this one: (Copy and paste it)
=IF(B2="","",(1+C2))

Greg.
Feb 25, 2014 at 09:13 AM

If you have occasional values in one cell, followed by differing blank cells below it until another value, insert a new column next to it and use this forumla: =IF(A1<>"",A1,0) for the top cell, followed by =IF(A2<>"",A2,B1) for all the remaining cells.

JEN
May 19, 2014 at 12:06 PM

Thanks issahamameh!!

statsstudent
Oct 1, 2014 at 09:53 PM

None of this has worked for me. Something like =IF(B2="","",(1+C2)) only makes the cell with the formula equals to C2+1. It doesn't add 1 to C2

Similar discussions

Excel - IF function with multiple words

Excel if range of cell contain a text put a cell value in

If cell = date return yes or no.

Copy data onto sheet only if cell has text

Highlight cell if another cell contains any text

If a cell contains any text then add a value (with dates)

If a cell contains any text then add a value

2 replies

Your reply

Similar discussions

Subscribe To Our Newsletter!