Math Gurus Inside

[Dr. Gonzo]

I'm trying to come up with an excel/algebra formula that will calculate the appraised value of property based on user input information. The user input information is the monthly property taxes and the property MIL rate.

The formula to calculate the monthly taxes based on the appraised value and MIL rate is:

F1=(0.7C1/1000)(B1)/12

F1 = Monthly Taxes
C1 = Appraised Value (known)
B1 = MIL Rate (known)

I cannot figure out or to "reverse engineer" this formula to solve for C1 as an unknown value and F1 as known value.

 

[Voltwings]

Just scribbling this out at work, if i understand your OP correct, it should be:


F1 = ((.7C1 / 1000)(B1))/12

12F1 = (.7C1/1000)(B1)

(12F1)/B1 = .7C1/1000

1000(12F1)/B1 = .7C1

1000(12F1)/.7B1 = C1

 

[Dr. Gonzo]

That's it! Greatly appreciated!

 

[KingBlack]

Excel has an add-on function called solve and it's able to do Matrix and maximization and minimization programming. That may help in any future algorithms that you may run into.