Microsoft Excel kimbery 30.09.2006 17:16:03 How do I do the IF function formula for calculating the shipping cost for an order If the standard shipping cost is $8.95 and express is $14.95

Re: Microsoft Excel joeu2004[ at ]hotmail.com 30.09.2006 17:21:06 kimbery wrote: [Quoted Text] > How do I do the IF function formula for calculating the shipping cost for an > order If the standard shipping cost is $8.95 and express is $14.95 Suppose A1 contains either "S" for standard or "E" for express. Then you could write: IF(A1="S", 8.95, 14.95)