Gwapo O.

asked • 07/27/18# Is there a shortcut formula to use whenever one of the values inside a formula changes?

I have this formula.

true=base×(1+A)×(1+B−C)×(1−D)×(1+E−F)×(1−G)

If the E increases its value, is there a way to know the adjusted true without having to calculate the whole formula again using the adjusted E?

For example this.

108.9=200×(1+0.1)×(1+0.4−0.2)×(1−0.5)×(1+0.5−0.4)×(1−.25)

If E increased by 0.5 making it 1, how do I get the adjusted true which is 158.4 without recalculating everything again?

Any of the letters can change it's value.

true=base×(1+A)×(1+B−C)×(1−D)×(1+E−F)×(1−G)

If the E increases its value, is there a way to know the adjusted true without having to calculate the whole formula again using the adjusted E?

For example this.

108.9=200×(1+0.1)×(1+0.4−0.2)×(1−0.5)×(1+0.5−0.4)×(1−.25)

If E increased by 0.5 making it 1, how do I get the adjusted true which is 158.4 without recalculating everything again?

Any of the letters can change it's value.

Follow
•
2

Add comment

More

Report

## 1 Expert Answer

## Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.

Most questions answered within 4 hours.

#### OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.