1 of 1 people found this helpful
I have done some changes in your calculation like the case statement and used Profit * .30 to get the output now its Profit display amount is showing $1,910 which is 30% of $6,368
but what you are trying to achieve $4,447 is 70% of $6,368.
Attached the workbook for your reference. I have set up calculation as per 30%
Please mark this answer Helpful & Correct answer to if it solves your problem