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/112312-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

sb1920alk

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

Teethless mama

Microsoft Excel

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

"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

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