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?