A FORMULA TO SOLVE THIS - HEADACHE WITH IF

[maddieyoung27]

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.

[TheTimeSavingCo]

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

 

[Stephen_Orr1]

Hi @maddieyoung27,

Give this a try

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

Then set the formula field formatting to percentage: