How to set up an IF formula in Excel

G

Guest

I have a spreadsheet that I need to calculate if our carrier delivers 'X'
number of parcels, then this must be multiplied by $1.50 plus add $2.50
delivery fee.
Not all deliveries are based on this, some have set rates in which case I
need no formula in them.
Can anyone help me??? (am a formula novice)

Thanks!!
 
B

broogle

Don't understand what you want.
if A1 = "X", then it can't be multiplied by number.
 
B

broogle

I assumed x is a number, then
=IF(A1=10,A1*1.5+2.5,"")

is that what you wanted?
 

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

Formula Help 1
calculate shipping costs in excel 2007 2
How do I create the formula for this calculation? 1
"If" formula 5
IF Formula and multiple formulas 1
What's the best way to set this formula up? 0
Help with nested functions / differing formulas based on number size 4
how to set up an IF formula 6

Top