Need help with a calculation

[Ssoriano0127]

Hello!

I have a question about a calculation, hoping somebody can help me.

So I need a formula to have one number subtracted by another number, then it has to be divided by another number but that number that its being divided by is minus 1. The number that is being divided by will always be -1. So for example currently I have it in the spreadsheet as 6, but it can be anywhere between 2-10 but with this formula when I go to divide its going to be -1. so instead of 6 I'm dividing by 5.

I hope that makes sense.

Example: $2000 - $500 = $1500 / 5-1(which is technically 4) =

Hope you guys can help !

Thanks!!!!

 

[jtakw]

Hi,

Do you mean this:

Book1
	A	B	C	D	E	F
1	Number	Number		Divisor		Result
2	$1,500	$500		6		$200
Sheet18

Cell Formulas
Range	Formula
F2	=(A2-B2)/(D2-1)

 

[Ssoriano0127]

That's it! Thanks so much!

 

[jtakw]

You're welcome, welcome to the forum.