Do not show $ per week when days remain < 7

  • Thread starter Thread starter Walterius
  • Start date Start date
W

Walterius

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
 
Thanks, Jason. It works fine.
Jason Morin said:
A1: $ Remaining
B1: Days Remaining in Month
C1: =A1/B1 ($ Remaining/Day)

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

HTH
Jason
Atlanta, GA
Click to expand...
 
Back
Top