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
Get step-by-step solutions from verified subject matter experts
