Microsoft Office excel 2007 home & stude...

I have 4 condition. I need to enter the value to O3 thru O200. First of all, I dont know what function should I use for those condition.

Secondly, Do I need to enter the function onto O3 thru O200 one by one. If it does, it is gonna take a lot of time.The condition:

If G3 <=1 and H3 <=1, the outcome is 2;

If G3 >1 and H3 >1, the outcome is 4;

If G3 >1 and H3 <=1, the outcome is 3;

If G3 <=1 and He >1, the outcome is 3;Thank you.

Try: =IF(AND(G3<=1,H3<=1),2,IF(AND(G3>1,H3>1),4,3))

Enter the formula in O3 and just drag it down to O200.

MIKE

Thank you, Mike

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History