Previous Topic Next Topic

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.

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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,"")
89
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'
0
issahamameh Posts 22 Registration date Friday October 19, 2012 Status Member Last seen June 22, 2013 1
Mar 18, 2013 at 02:16 PM
Please try this one: (Copy and paste it)
=IF(B2="","",(1+C2))
1

Similar discussions

Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Copy data onto sheet only if cell has text
danipants -
checjb -

17 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Excel - To generate unique ID
wliang -
ferg -

4 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses