If and And statements in Excel

December 12, 2012 at 09:11:08
Specs: Windows 7
I need the following... having a hard time making it work.

If A4=H3 AND the text in C4=pig, then show a 1 in H4.
If A4 is blank, then show blank in H4.
If A4=H3, but text in C4 is not=pig, then show blank in H4.

Help?


See More: If and And statements in Excel

Report •

#1
December 12, 2012 at 09:55:00
Homework???
:-)

We do not support homework here.
Use the help function of Excel for IF statements or use google for IF statement in Excel.


Report •

#2
December 12, 2012 at 11:10:19
found this with Google search

http://www.bluemoosetech.com/micros...

it always pays to search. :)

:: mike


Report •

#3
December 12, 2012 at 11:29:54
No, not home work. But glad to know that highschool learning isn't gaining from help here.

It does pay to search... will search for another site to gain knowledge, not someone telling me to look it up. Gosh, why didn't I think of that?


Report •

Related Solutions

#4
December 12, 2012 at 14:13:07
Try this:

=IF(AND(A4=H3,C4="pig"),1,"")

MIKE

http://www.skeptic.com/


Report •

Ask Question