Excel Mutiple Condition

Microsoft Office excel 2007 home & stude...
July 18, 2010 at 16:23:04
Specs: Windows Vista
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.


See More: Excel Mutiple Condition

Report •

#1
July 18, 2010 at 17:36:01
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

http://www.skeptic.com/


Report •

#2
July 18, 2010 at 22:18:28
Thank you, Mike

Report •

#3
July 19, 2010 at 06:56:21
Glad I could help.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question