| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
entering a formula into a cell with text
I have a spreadsheet that has a "shipping" fee of "Standard=4.99" and an
"Overnight=12.99". I need to insert an IF function if I change it from standard to overnight to automatically change and I can't get it. Can you assist me with this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
entering a formula into a cell with text
if you "Standard=4.99" was in column A, try this:
=if(A1="standard=4.99",4.99,12.99) if those are not the only two options then replace the 12.99 with if(A1="overnight=12.99",12.99, ... and so on. good luck "TV" wrote: I have a spreadsheet that has a "shipping" fee of "Standard=4.99" and an "Overnight=12.99". I need to insert an IF function if I change it from standard to overnight to automatically change and I can't get it. Can you assist me with this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
entering a formula into a cell with text
IF(A1="Standard", 4.99, 12.99)
If this is not what you need please explain in more detail with examples best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "TV" wrote in message ... I have a spreadsheet that has a "shipping" fee of "Standard=4.99" and an "Overnight=12.99". I need to insert an IF function if I change it from standard to overnight to automatically change and I can't get it. Can you assist me with this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
entering a formula into a cell with text
I guess I did not explain myself correctly, so here it goes: I have a
spreadsheet that has C15 that shows the shipping of either "standard or overnight" then I have the shipping options in E9 standard F9 4.99, E10 overnight F10 12.99, then on the bottom of the invoice I have F32 where the Shipping fee is supose to go in and the formula, and in G32 I should be able to change from overnight to standard and changes should me made throughout the invoice. But this is kind of confusing to me and I can't get it. Hope you can help! "Bernard Liengme" wrote: IF(A1="Standard", 4.99, 12.99) If this is not what you need please explain in more detail with examples best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "TV" wrote in message ... I have a spreadsheet that has a "shipping" fee of "Standard=4.99" and an "Overnight=12.99". I need to insert an IF function if I change it from standard to overnight to automatically change and I can't get it. Can you assist me with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering a function leaves the cell in text mode... | Excel Discussion (Misc queries) | |||
| How to protect cell with formula from being entering info | Excel Worksheet Functions | |||
| after entering a text in one cell, next cell should disp the entd | Excel Discussion (Misc queries) | |||
| text in a cell upon entering the cell | Excel Discussion (Misc queries) | |||
| What is the Chr() code for Alt+Enter in a cell when entering text? | Excel Discussion (Misc queries) | |||
Linear Mode
