entering a formula into a cell with text

  • Thread starter Thread starter TV
  • Start date Start date
T

TV

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?
 
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
 
IF(A1="Standard", 4.99, 12.99)
If this is not what you need please explain in more detail with examples
best wishes
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine text and formula 7
enter numbers without decimal places 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
How do I format a cell to calculate overnight Hours? 7
Excel formula(?) for choosing only 1 cell.. 1
Formula for inserting a $ amount in a Column if certain met 3
Open Lotus Notes with Excel Macro 3
Using IF functions to calculate shipping cost and methods 1

Back
Top