Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

A FORMULA TO SOLVE THIS - HEADACHE WITH IF

Topic Labels: Formulas
810 2
cancel
Showing results for 
Search instead for 
Did you mean: 
maddieyoung27
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

Hmm, 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

Screenshot 2023-06-14 at 7.31.08 PM.png

Hi @maddieyoung27,

Give this a try

IF({Q2 avg month revenue} > 1500, 0.7, 0.8)

Then set the formula field formatting to percentage:
formatting.png