My first field is current MMR which ill name here as A and my 2nd field is desired MMR which ill name B so i'm trying to make a calculation that will change my price by the values in A and B if B is 2500 value or less then my formula should be (B-A) *0.05 , if my B is from 2500 to 3500 then my formula is: (B-A)* 0.08 , if B is from 3500-4500 the formula should be (B-A)*0.12 , if B is from 4500 to 5500 then my formula should be (B-A)*0.27 , if my B has values from 5500-6000 then my formula should be (B-A)*0.7 and if my B has value from 6000 to 6500 then my formula should be (B-A)*0.99 . I'm having issues with writting the proper formula, since it only wants to accept my first equasion. Need help badly.
