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" wrote in message
...
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?