•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
US Veterans Disability Formula with Bilateral Calculation
File link in the comments.
Regular and Bilateral Disability Formula
=LAMBDA(regular,[bilat], LET( r, regular, b, bilat, f, LAMBDA(x, 100 - REDUCE(100, x / 100, LAMBDA(a,v, ROUND(a*(1-v),0)))), r_rate, f(r), b_rate, f(b), c_rate, f(VSTACK(r, ROUND(b_rate * 1.1, 0))), HSTACK( VSTACK("Reg Unrounded","Reg Rounded","Bilat","Bilat + 10%","Reg + Bilat", "Full Disability Rating"), VSTACK(r_rate,ROUND(r_rate,-1),b_rate,ROUND(b_rate * 1.1, 0),c_rate,ROUND(c_rate,-1)) ) ) )(A2:A7,B2:B6) Bilat is an optional argument. So, in this example, you would just type (A2:A7), if you had zero bilateral ratings.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#no-code spreadsheet solutions
#Excel compatibility
#rows.com
#Excel alternatives for data analysis
#row zero
#financial modeling with spreadsheets
#Veterans Disability
#Bilateral Calculation
#Disability Formula
#Regular Disability
#Bilat
#LAMBDA Function
#Disability Rating
#Optional Argument
#Excel Formula
#VSTACK
#HSTACK
#ROUND Function
#REDUCE Function