Multiple logic functions with multiple sums

[BARRETTMARKB]

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

I believe the formula calls for "if" functions but maybe there'
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(f16>0=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

 

[Spencer101]

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

I believe the formula calls for "if" functions but maybe there'
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(f16>0=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

Hi Mark,

What happens if F16 is greater than or equal to 5.7?

Also, you've said you want that additional condition added. Do you mea
added to the original formula or in another cell?

The reason I ask is, it doesn't fit in with the other conditions an
could conflict with them giving spurious results.

S

 

[BARRETTMARKB]

Hi Mark,

What happens if F16 is greater than or equal to 5.7?

Also, you've said you want that additional condition added. Do you mea
added to the original formula or in another cell?

The reason I ask is, it doesn't fit in with the other conditions an
could conflict with them giving spurious results.

S.

Hello Spencer,

Thanks for the speedy reply.

This portion of the budget is a continuing monthly event based on a (4
week to (5) week cycle. So I don't need it to divide the total due b
any more than (5) weeks.

F16 represents the amount left to pay from the total.

Check out this example:

D16 = (-) $1,000 (total)
F16 = (-) $500 (left to pay)
C16 = (+) 5 (weeks till due)
E16 = (-) $100 (pay per week)

The extra condition "=if(f16>0=sum(d16/5))" comes in when F16 becomes
positive number. Once the total left to pay (F16) becomes a positiv
number, the number of weeks until the total is due (C16) becomes les
important. The payments per week (E16) still needs to continue and b
effective.

Like this example:

D16 = (-) $1,000 (total)
F16 = (+) $50 (left to pay)
C16 = (+) 2 (weeks till due)
E16 = (-) $200 (pay per week)

On a (-)$1,000 monthly total (D16) it's pointless for me to divide th
total left to pay (F16) by the number of weeks until the total is du
(C16) when (F16) is only (+)$50. The payments per week will be too smal
and will quickly end up back in deficit. So my solution is to divide th
total due by the maximum number of weeks to pay (5) :

=if(f16>0=sum(d16/5))

This appears to me to be the best accounting solution for putting al
the numbers in the plus. Unfortunately my knowledge of excel function
are limited. This is where I really need some help.

Thanks again.

Mark