Forum Discussion
Function 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...
Hi Deanna, this formula do the Job. Your value is in A1:
=0.08+(ROUNDUP(A1-500000,-5)/10000000)