User Profile
AustinFindley
Copper Contributor
Joined Sep 16, 2021
User Widgets
Recent Discussions
Re: Complicated formula, need some help!
Thank you, this is a good idea. I tried Mr Baklans solution, but I feel that when I move that logic to my main spreadsheet, I will undoubtably mess it up. But still, thank you Mr. Balkan for the work because I know understand the HOW and WHY for what I can doing. And Mathetes, thank you for that outside the box idea. Because there are actually several more less complicated variables to what I am working on, I think these helper columns will allow me to compartmentalism the different variables and simplify the data.1.7KViews0likes0CommentsRe: Complicated formula, need some help!
Thank you, I apologize for not getting back sooner. I’ve been out of the office. I forgot to mention in my original post that the other criteria that has to be met is that the individuals “MOS” has to match the MOS for the required points. So in my example there are 35M and 35N both of these MOS will have different varying promotion points from month to month. How would I go about adding that condition into the true/false? CPL Jim Donut is a 35M with 800 points and so meets the point requirements and is highlighted green. SPC Bingo Bongo only has 200 points and does not meet his requirements and is highlighted orange.1.7KViews0likes4CommentsComplicated formula, need some help!
I am trying to come up with a formula using conditional formatting that will highlight an individuals name green if the person has met certain requirements. I understand the logic of what I am trying to do, but I don’t speak the language well enough! If you haven’t served in the military and need to get familiar with some of the Jargon that Im dealing with, here is some key info- SPC and CPL are the same pay grade and Promote to SGT SGT SZ means Secondary Zone promotion from SPC or CPL to SGT. This is an earlier promotion than SGT PZ (Primary Zone) The Primary zone will have greater than or equal to points to the secondary zone (but never less than). SGT is the rank above SPC or CPL and Promoted to SSG. SSG SZ and SSG PZ are the same concept as above but one pay grade higher. Im order for a Soldier to promote, the need a certain amount of points based on several variables that add to the total points. My actual spreadsheet has each section broken down and added up to make the total. My goal is to simply create a comparison based on True and False. I attached a sample spreadsheet that has some prefilled cells to match my logic here- IF NAME is a SPC OR CPL AND has TOTAL POINTS GREATER THAN OR EQUAL TO SGT SZ highlight his name in a Green fill IF NAME is a SGT and has greater than or equal total points to SSG SZ highlight his name green. I hope this makes sense, How do I format that?Solved1.9KViews0likes6Comments
Recent Blog Articles
No content to show