Deanna_WilsonCopper ContributorOct 12, 2022Function help Hello, I apologize if this is fairly beginner but I'm not finding an answer by searching. How do I do the following? If cell X is less than or equal to 500000, 0.08 , if greater than 5000...Show More
JoeUser2004Bronze ContributorOct 13, 2022Deanna_Wilson With your amount in A1: =0.08 + 0.01*MAX(0, (CEILING(A1, 100000) - 500000) / 100000)
