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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History