Good day,
I have the below pivot in excel

Please assist with a formula for the calculated column (% Achieved).
% Achieved is calculated by dividing the Actual by the Target.
This calculation is based on the Ind value. If Ind = 1.5, then we cap the division to 150%, if Ind = 3, then cap the division to 300%.
Please advise,
Many thanks,
Regards,
