Help needed with IF Statement

[howlett1988]

I need to make an IF statement. Although this may sound a bit complicated i hope someone can help me produce one.

I need to produce an IF statement where if i send a letter that weighs 100g first class it costs 32p and if i send it 2nd class it costs 23p.

thanks

[Carim]

Hi,

But the weight does not seem to modify price ...
If you input class selected in cell B1, in cell C1 type

=IF(B1="1st","32p","23p")

HTH
Carim

[howlett1988]

sorry - have worded it slightly wrong -here goes again.
although the formula below is wrong as it says there are too many arguments, hopefully you can see what i am trying to do

=IF(b14=Packet,b8<=100,b11=1,"100")

i dont know how to write 'if this AND this AND this is this then the price is 100'
i really cant word this correctly


thanks for the advice anyway

[Carim]

Ok then ...

In cell B11 type following formula ...

=IF(And(b14=Packet,b8<=100),1,"100")

HTH
Carim

[howlett1988]

Ive tried what you sed and just get #NAME?

[Carim]

Sorry, ...
not attentive enough ...

=IF(And(b14="Packet",b8<=100),1,100)

HTH
Carim