Thread: Microsoft Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
sb1920alk sb1920alk is offline
external usenet poster
 
Posts: 100
Default Microsoft Excel

Let's say you indicate in A2 whether the item in A1 requires standard or
express shipping

In A3 type:

=IF(A2="Express",14.95,8.95)

Regards,

"kimbery" wrote:

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