Forum Discussion

MaverickCS5's avatar
MaverickCS5
Copper Contributor
Aug 20, 2024

Looking for the right formula.

Hi guys,

 

Looking for the right formula that will let me enter in a text criteria and then subtract a certain number from the value 100, based on what text is matched.

 

i.e score is currently 100 but if No is entered in various cells, then the value is reduced by 20 each time it is. 

 

How would I go about this?

excel
Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Aug 20, 2024
    something like
    =IF( c2="no", A2-20, A2)
    or if you want to do multiple
    =A2-COUNTIF(C2:F2, "no")
    note the cells and ranges are made up as I don't understand which cells you are looking at to check if they are "no" and which cell or cells are supposed to have the value in them