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,...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 14, 2023

    AndyK1865 

    =IF(O9=3,COUNTIF(P9:S9,"YES")*33/100,IF(O9=4,COUNTIF(P9:S9,"YES")*25/100,""))

    You can try this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 14, 2023

AndyK1865 

=IF(O9=3,COUNTIF(P9:S9,"YES")*33/100,IF(O9=4,COUNTIF(P9:S9,"YES")*25/100,""))

You can try this formula.

 

  • AndyK1865's avatar
    AndyK1865
    Copper Contributor
    Feb 14, 2023
    you little star thank you