Bev, something like this, =IF(A1=200,25,15)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Bev Greene" wrote in message
...
I am making a invoice template. The shipping will be $15 if the sales are
less than $200 and $25 for all orders $200 and over. What formula do I
enter?

Thanks
Bev