Hello, I currently have this question needing to solve "If a branch's average monthly gross revenue in the last quarter is higher than $1500, its revenue split rate will be 80%, or else it will be 70%"
I want the result to show Percentage 80% and 70% as result because after that I will use them to calculate the net revenue. ASAP. Thank you.
A FORMULA TO SOLVE THIS - HEADACHE WITH IF
+31Hmm, what problems are you facing with setting this up? I've set something up here for you to check out to see if it helps
+18Hi @maddieyoung27,
Give this a try
IF({Q2 avg month revenue} > 1500, 0.7, 0.8)Then set the formula field formatting to percentage:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.