Forum Discussion
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 1...
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
=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