Aquarianguy
New Member
- Joined
- Jul 23, 2010
- Messages
- 3
Hi, I'm trying to create a simple sheet, 5 columns, Monday through Friday. You enter the value for the day into Row B. Row C cumulatively adds the days' data throughout the week.
Simple enough, but I'm trying to format it so that C2, C3, C4, C5 won't appear UNTIL a value is entered into B2, B3, B4, B5.
=IF(B2>=0, C2, 0) then formatting the text as white if it's 0, but that won't show Tuesday's cumulative number if 0 were entered.
I think I'm missing something obvious.
Any help is appreciated, and please forgive the novice-sounding question. And Thanks!
Simple enough, but I'm trying to format it so that C2, C3, C4, C5 won't appear UNTIL a value is entered into B2, B3, B4, B5.
=IF(B2>=0, C2, 0) then formatting the text as white if it's 0, but that won't show Tuesday's cumulative number if 0 were entered.
I think I'm missing something obvious.
Any help is appreciated, and please forgive the novice-sounding question. And Thanks!