Solved How to find a value

January 20, 2015 at 06:49:16
Specs: Windows 7
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?

See More: How to find a value

Report •

January 20, 2015 at 07:57:13
✔ Best Answer
I'm confused.

You said: "if 3 are >=100% i multiply by 75%"

Multiply what by 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.


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

Report •
Related Solutions

Ask Question