Related:
- If date exists (or any value) in B2, return value of 1 to C2
- Fnaf 1 download pc - Download - Horror
- Tentacle locker 1 - Download - Adult games
- Five nights in anime 1 - Download - Adult games
- Igi 1 download - Download - Shooters
- Poppy playtime chapter 1 download pc - Download - Horror
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
May 3, 2016 at 11:45 PM
May 3, 2016 at 11:45 PM
Hello T,
Please put the below mentioned formula in C2 and drag the formula in the entire Column C:
=IF(ISBLANK(B2),"",1)
In case, you want to have a zero (0) instead of blank then you can replace "" with 0 in the formula.
Hope this helps.
Please do write back to us.
Please put the below mentioned formula in C2 and drag the formula in the entire Column C:
=IF(ISBLANK(B2),"",1)
In case, you want to have a zero (0) instead of blank then you can replace "" with 0 in the formula.
Hope this helps.
Please do write back to us.
May 12, 2016 at 04:05 PM
Sorry for the late reply! I just noticed the response. That absolutely worked! Now if there is a value it shows 1, and if its blank it shows 0
If you have any extra time, can you help me understand what each of the values is doing in your formula? So I can understand the logic?
=IF(ISBLANK(B2),"",1)
Just so I can make logical sense of it and use it for other applications:
The formula is saying, if cell B2 is blank, then the value in "" should be in cell c2, and if its not blank, use the value after the comma? so return 1?
Someone explained to me in Vlookup's that the formula argument ends with ,0) to tell excel to finish, but it seems in this formula you ended with ,1) so it intrigued me to ask the question
May 12, 2016 at 04:07 PM
Is it possible if Cell B2 and cell C2 both had values of dates or anything else, that D2 would add 1+1 to equal 2?
To add context, i track weekly activity, so if it shows up on week 1 and week 3, i would love a column to say it was visited 2 times within in the month because its adding 1+1
--If visited in week 1, 2 & 3 .column D2 should say visited 3 times
Hope that's not too difficult!
Thank you again
-T