Forum Discussion

AndyK1865's avatar
AndyK1865
Copper Contributor
Feb 14, 2023
Solved

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

 

 

 

 

Resources