Microsoft Excel

K

kimbery

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
 
S

sb1920alk

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,
 
Top