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