Excel Help: As one cell decreases in value by 1, another cell increases by $36,422.4

[BellaBarr]

Hi team! I believe this is a simple ask but it is one that I am still struggling with as I am a novice. Essentially, as the # of session decreases by 1, (5 being the max value as you see in the picture below), the redirected funds increases by $36,422.4. Obviously the maximum the redirected funds can ever get to is $182,112.

Many thanks!
B

 

[Leo Skywalker]

Use this formula:

B2=(6-A2)*36422.4

 

[BellaBarr]

T

Use this formula:

B2=(6-A2)*36422.
[/QUOTE]

Thank you!!
Only a slight variation: B2=(5-A2)*36422.4

 

[Leo Skywalker]

You're welcome!

I thought the redirected funds started at 5 Sessions with $36K, down to 1, that's why I used "6".
It seems that it goes from 5 to 0, starting in $0.

Please mark as SOLVED.