Hi all
Hope you can help! I need a formula to return a proportion of a figure based on text criterion from another field. Specifically (see picture and spreadsheet at the link below) I want cell Q2 to display 80% of the figure in cell O2 (10,000) based on the text in cell P2 ("High").
https://docs.google.com/spreadsheets/d/1d3Tq9NvKy3JTQl1TeuoNyNXs8djv5uAk6q1cF1_Pxro/edit?usp=sharing
I thought of a sumif(s), but I'm struggling with how to calculate the proportion as part of the formula. I would really appreciate any help as to tips for approaches to take.
Thanks in advance
Ben
Hi Ben
Do you want the percent to change depending on the Risk? So High would be 80%, Med 60% and Low 40%?
I have never used Google Sheets but the formula works the same as i would use in Excel
=IF(P2="High",O2*80%, IF(P2="Med",O2*60%, IF(P2="Low",O2*40%)))
Purfleet
Looks great. Many thanks Purfleet that's very helpful!
