I'm currently putting together a budgeting worksheet and I've hit a bit of a snag.

I believe the formula calls for "if" functions but maybe there's something better?

Should it look something like this?:


=if(C16<1.7=SUM(F16)),
if(C16<2.7=SUM(F16/2)),
if(C16<3.7=SUM(F16/3)),
if(C16<4.7=SUM(F16/4)),
if(C16<5.7=SUM(F16/5))

I also want to add another condition:

=if(f160=sum(d16/5))

I need the solution to appear in one cell, "E16"

key:

C16 = "weeks till due date"
F16 = "total left to pay"
D16 = "total cost"
E16 = "weekly payments"

Thank you very much. Any help is greatly appreciated.

Mark B