I have a formula that reads It reads
[closing costs] - 400/2
Closing costs -(minus) 400/ (divided)2
Example: Closing costs 1950.00 -400= 1550/ 2 = 775 But I am getting the wrong calculation - it is coming out at 1750.00
Solved
formula help
+8Best answer by MarkShnierYou
..so in math, there something called the order of operations. I think probably way back in grade 5 or something like that I'm nerdy enough to still remember my teacher telling me BOMDAS
That stands for
Brackets
Of (as in 5% of x)
MD (Multiplication and Division)
AS (Adition and Subtraction)
BOMDAS
That means that in the absence of any Brackets, it will always do the Multiplication and Division first and then do the Addition and Subtraction next.
Probably you want your formula to read like this
([closing costs] - 400) / 2
Other words take the closing costs, subtract 400, and then take the result of that, divided in half
This topic has been closed for replies.
+24..so in math, there something called the order of operations. I think probably way back in grade 5 or something like that I'm nerdy enough to still remember my teacher telling me BOMDAS
That stands for
Brackets
Of (as in 5% of x)
MD (Multiplication and Division)
AS (Adition and Subtraction)
BOMDAS
That means that in the absence of any Brackets, it will always do the Multiplication and Division first and then do the Addition and Subtraction next.
Probably you want your formula to read like this
([closing costs] - 400) / 2
Other words take the closing costs, subtract 400, and then take the result of that, divided in half
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.