How to set up an IF formula in Excel

[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!!

 

[Peo Sjoblom]

=IF(A1=X,A1*1.5+2.5,"")

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Guest]

THANKS!!!

=IF(A1=X,A1*1.5+2.5,"")

--
Regards,

Peo Sjoblom

(No private emails please)

 

[broogle]

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

 

[broogle]

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

is that what you wanted?