Question: EXCEL help! I am trying to use excel to solve an equation that repeatedly subtracts 500 each time. How can I make a function that

EXCEL help! I am trying to use excel to solve an equation that repeatedly subtracts 500 each time. How can I make a function that decreases each time?

My equation is: P = [ 10,084.68 * (10,915.5 - 500) ] + 597.9

I want to find the different values of P by doing 10,915.5 - 500 repeatedly until the 10,915.5 reaches 0.

Please help! Thank you!

Edit: I need a step-by-step on how I would use Excel to define my equation and then how I can subtract -500 continually from 10,915.5 until the 10,915.5 value equals 0.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!