Prev: Looking for Excel template for fluid balance chart (nursing)
Next: Row 3 data
From: Cindyt on 29 Apr 2010 11:19
Hi - I need your expert help. This should be easy-but cannot figure it out

I have a simple spreadsheet that keeps track of "items in", "items out" and
"carry over" by day. Since I do it by month, the formula shows the "carry
over" number all through the end of the month. I do not want it to show up
until the date is current, and then not go away on the previous columns.
ie.
Date 4/1/10 4/2/10 4/3/10 4/4/10 4/5/10 4/6/10 4/7/10
Work in 10 10 12
Work out 8 5 18
Carry Over 2 7 1 1 1 1 1

Any help would be greatly appreciated! ct






From: Bob I on 29 Apr 2010 11:27
Perhaps Conditional Formatting that makes Font White if "today() > cell
with Date.

Cindyt wrote:

> Hi - I need your expert help. This should be easy-but cannot figure it out
>
> I have a simple spreadsheet that keeps track of "items in", "items out" and
> "carry over" by day. Since I do it by month, the formula shows the "carry
> over" number all through the end of the month. I do not want it to show up
> until the date is current, and then not go away on the previous columns.
> ie.
> Date 4/1/10 4/2/10 4/3/10 4/4/10 4/5/10 4/6/10 4/7/10
> Work in 10 10 12
> Work out 8 5 18
> Carry Over 2 7 1 1 1 1 1
>
> Any help would be greatly appreciated! ct
>
>
>
>
>
>

From: BSc Chem Eng Rick on 29 Apr 2010 11:28
Cindy,

In carry over formula, try:
=if(today()>=B1,B2-B3,"")
Where B1 is your Date cell.

--
If this helps, please click "Yes"
<><><><><><><><><><><>


"Cindyt" wrote:

> Hi - I need your expert help. This should be easy-but cannot figure it out
>
> I have a simple spreadsheet that keeps track of "items in", "items out" and
> "carry over" by day. Since I do it by month, the formula shows the "carry
> over" number all through the end of the month. I do not want it to show up
> until the date is current, and then not go away on the previous columns.
> ie.
> Date 4/1/10 4/2/10 4/3/10 4/4/10 4/5/10 4/6/10 4/7/10
> Work in 10 10 12
> Work out 8 5 18
> Carry Over 2 7 1 1 1 1 1
>
> Any help would be greatly appreciated! ct
>
>
>
>
>
>
From: Bob I on 29 Apr 2010 11:30
Typo, should be <

Bob I wrote:

> Perhaps Conditional Formatting that makes Font White if "today() > cell
> with Date.
>
> Cindyt wrote:
>
>> Hi - I need your expert help. This should be easy-but cannot figure
>> it out
>>
>> I have a simple spreadsheet that keeps track of "items in", "items
>> out" and "carry over" by day. Since I do it by month, the formula
>> shows the "carry over" number all through the end of the month. I do
>> not want it to show up until the date is current, and then not go
>> away on the previous columns.
>> ie.
>> Date 4/1/10 4/2/10 4/3/10 4/4/10 4/5/10
>> 4/6/10 4/7/10
>> Work in 10 10 12
>> Work out 8 5 18
>> Carry Over 2 7 1 1 1 1 1
>>
>> Any help would be greatly appreciated! ct
>>
>>
>>
>>
>>
>>
>

From: Cindyt on 30 Apr 2010 08:51
Thank you - worked like a charm!

"BSc Chem Eng Rick" wrote:

> Cindy,
>
> In carry over formula, try:
> =if(today()>=B1,B2-B3,"")
> Where B1 is your Date cell.
>
> --
> If this helps, please click "Yes"
> <><><><><><><><><><><>
>
>
> "Cindyt" wrote:
>
> > Hi - I need your expert help. This should be easy-but cannot figure it out
> >
> > I have a simple spreadsheet that keeps track of "items in", "items out" and
> > "carry over" by day. Since I do it by month, the formula shows the "carry
> > over" number all through the end of the month. I do not want it to show up
> > until the date is current, and then not go away on the previous columns.
> > ie.
> > Date 4/1/10 4/2/10 4/3/10 4/4/10 4/5/10 4/6/10 4/7/10
> > Work in 10 10 12
> > Work out 8 5 18
> > Carry Over 2 7 1 1 1 1 1
> >
> > Any help would be greatly appreciated! ct
> >
> >
> >
> >
> >
> >
 | 
Pages: 1
Prev: Looking for Excel template for fluid balance chart (nursing)
Next: Row 3 data