get IF statement

Hei,

I need some help, propably simple as hell for most of you, but i cannot figure it out in Excel 2007

Please Login or Register  to view this content.

<- this works. If purchase order is more than 1000, shipping is free, otherwise it is 20 $.

Please Login or Register  to view this content.

<- this doesn't work. It's basically the same as previous, but in addition i want to make sure that if client inserts nothing and the sum is 0, so the shipping would also be 0$

How should i make myself understandable for Excel2007?
Any help is really appreciated, like always.

Thanks in advance

Try =IF(and(D18>=1000, D18<=0),0,20)

Changing the OR to an AND won't work. The Ref can never be greater than or equal to 1000 and less than or equal to 0. It is impossible

The original formula is correct.

Please Login or Register  to view this content.

if d18 is less than or equal to 0 or greater than or equal to 1000, then the shipping is 0. Any value greater than 0 or less than 1000 will result in $20 shipping.

What isn't working in the formula?

funny that it works for me

=IF(OR(D18>=1000, D18<=0),0,20)
0 in d18 returns 0
>1000 in d18 returns 0
anything else 20

A different formula that would return the same results would be:

Please Login or Register  to view this content.

Thank You all for replies.

Tried Your suggestions, whallgren and arthurbr, Excel responds: the formula you typed contains an error.

shg's (sorry for the language, it means nothing where i'm from) suggestion worked, but why? I could swear i tried that version, propably missed one comma or sth.

What's with the commas and semicolons and different versions of Excel?

Regards,

Thanks

Nice to know about the Regional Settings trick also.

Regards