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

Please Login or Register  to view this content.

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 ...

Please Login or Register  to view this content.

HTH
Carim

[howlett1988]

Ive tried what you sed and just get #NAME?

[Carim]

Sorry, ...
not attentive enough ...

Please Login or Register  to view this content.

HTH
Carim

[rjahr01]

=IF(C24<100,32,23)

with cell c24 being the package weight