Forum Discussion
AndyK1865
Feb 14, 2023Copper Contributor
Two percentages from same cell
Hi all
Im trying to set up a formula to create if I select Column O at 4 it calculates at 25% and select Column O at 3 at 33%
Currently have =COUNTIF(P9:S9,"YES")*33/100 and =COUNTIF(P9:S9,"YES")*25/100
but asking if there's a way if I select 3 in Column O it selects =COUNTIF(P9:S9,"YES")*33/100 and if theres 4 in Column O it selects =COUNTIF(P9:S9,"YES")*25/100
=IF(O9=3,COUNTIF(P9:S9,"YES")*33/100,IF(O9=4,COUNTIF(P9:S9,"YES")*25/100,""))
You can try this formula.
- OliverScheurichGold Contributor
=IF(O9=3,COUNTIF(P9:S9,"YES")*33/100,IF(O9=4,COUNTIF(P9:S9,"YES")*25/100,""))
You can try this formula.
- AndyK1865Copper Contributoryou little star thank you