I am trying to create a spreadsheet that states out of 4 cells if 3 are >=100% i multiply by 75% if 2 are >=100% then i multiply by 50% and if 1 is >=100% i multiply by 25% how would i formulate this?

I'm confused. You said:

"if 3 are >=100% i multiply by 75%"Multiply

whatby 75%?You also don't say what should happen if all 4 cells or none of the cells are >=100%

In any case, have you looked at COUNTIF?

Something like this, which looks at A1:A4 as the 4 cells and multiplies A1 by your values.

=IF(COUNTIF(A1:A4,">=100%")=3,A1*0.75,

IF(COUNTIF(A1:A4,">=100%")=2,A1*0.5,

IF(COUNTIF(A1:A4,">=100%")=1,A1*0.25,"")))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll