Thread: Microsoft Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Microsoft Excel

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


Suppose A1 contains either "S" for standard or "E" for express. Then
you could write:

IF(A1="S", 8.95, 14.95)