Hi All,
I've been racking my brain for the last few hours and have finally admitted defeat and need to ask for some help from the Excel gods. I am creating an Order Form for my business and have just added a section for the shipping cost. I think I have done it half way but I just cannot get over this last hurdle. So what I want the charges to be is that items totalling less than £100, incurs a £5.99 shipping cost. Orders over £100, the shipping cost will be free. Rightly or wrongly, I have used the formula below and it has kinda done what I have asked for.
=IF(I47<100,"£5.99","£4")
However, I would like it if the cell for the shipping costs, was £0 until someone has put an item in the basket. At the moment, without anything being choose, the total already says £5.99 as it is less than £100.
Any help would be so much appreciated!
Thanks,
Kev
Bookmarks