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.
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(B2<>"",c2+1,"")
if you insist on condition that if B2 is text then the fomula in D2 is
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.
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.
for example
You use =IF(ISTEXT(B1), 1,"")