Please see the attached for help with a formula. Thank you!!!
L Leigh Kuavopalo New member Joined Mar 11, 2016 Messages 2 Reaction score 0 Points 0 Mar 11, 2016 #1 Please see the attached for help with a formula. Thank you!!! Attachments Excel Formula.JPG 28.3 KB · Views: 20
Ron Coderre Member Joined Aug 11, 2015 Messages 110 Reaction score 1 Points 16 Location Boston, MA Excel Version(s) 2013, 2016, O365 Mar 11, 2016 #2 Using your posted scenaro... AB1900.00277.09%900.00350.00%900.00 Try this formula, copied down: C1: =B1*IF(AND(A1<=77.09%,A1<>""),0.5,1) These are the results: ABC1900.00900277.09%900.00450350.00%900.00450 Is that something you can work with?
Using your posted scenaro... AB1900.00277.09%900.00350.00%900.00 Try this formula, copied down: C1: =B1*IF(AND(A1<=77.09%,A1<>""),0.5,1) These are the results: ABC1900.00900277.09%900.00450350.00%900.00450 Is that something you can work with?
L Leigh Kuavopalo New member Joined Mar 11, 2016 Messages 2 Reaction score 0 Points 0 Mar 16, 2016 #3 Thank you Ron!!! It worked Very much appreciate your quick response.