| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) | |||
| enable automatic refresh | Excel Worksheet Functions | |||
| Installing: Microsoft Excel Feature | Excel Discussion (Misc queries) | |||
| Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
| Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
Hybrid Mode
