ok, so i've designed IF statments for cars like this one:
=IF(AND(E7<7000,E7<7001),"Yes","No")
is this statement right, for saying that if the car is above $7000 it will say no and if the car below $7000 it will say yes.
Now i want to design an IF statment that specifys Yes or No. that says yes if its a hatch or sedan and no if its a wagon.
how would i do that, i tried putting letters in instead of the numbers and that didn't work.
also anyone that has msn that i can add them so they can help me if they want to.
thx in advance for any help.