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