ExcelBanter - Microsoft Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Microsoft Excel (https://www.excelbanter.com/excel-discussion-misc-queries/112311-microsoft-excel.html)

kimbery

Microsoft Excel

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

[email protected]

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)

All times are GMT +1. The time now is 07:13 PM.