Do not show $ per week when days remain < 7

I have a spreadsheet that calculates the amount of money remaining per day
for the month($remain/daysremain) and per week ($remain per day * 7) for the
month. But the per week logic fails when there are less than seven days
remaining in the month.

How can I teach excel to use $remain when daysremain < 7?

A1: $ Remaining
B1: Days Remaining in Month
C1: =A1/B1 ($ Remaining/Day)

D1:
=IF(B1<7,A1,C1*7)

HTH
Jason
Atlanta, GA

"Walterius" wrote:

> I have a spreadsheet that calculates the amount of money remaining per day
> for the month($remain/daysremain) and per week ($remain per day * 7) for the
> month. But the per week logic fails when there are less than seven days
> remaining in the month.
>
> How can I teach excel to use $remain when daysremain < 7?
>
>
>

Thanks, Jason. It works fine.
"Jason Morin" <[email protected]> wrote in message
news:[email protected]...
> A1: $ Remaining
> B1: Days Remaining in Month
> C1: =A1/B1 ($ Remaining/Day)
>
> D1:
> =IF(B1<7,A1,C1*7)
>
> HTH
> Jason
> Atlanta, GA
>
> "Walterius" wrote:
>
> > I have a spreadsheet that calculates the amount of money remaining per
day
> > for the month($remain/daysremain) and per week ($remain per day * 7) for
the
> > month. But the per week logic fails when there are less than seven days
> > remaining in the month.
> >
> > How can I teach excel to use $remain when daysremain < 7?
> >
> >
> >