formula with 2 different prices

Hi everybody

if i want to create a formula in excell - I am selling raffle ticket - one costs 2 euro but 5 cost 5 euro - can i create a formula saying if in a1 value is amound < or = 4 the row b would calculate a1 *2, but if the value in a1 is 5 or 10 - it would be equal 5 to 5 and 10 to 10?

How can i apply this condition... I am not good with this and been trhing all day..

Can i apply the formul to the word document as well? if i want to create a word form?

Thank you for your time and help.

Milan

Perhaps in B1 =IF(A1<=4,A1*2,A1)

Thank you very much, i really appriciate your quick resond and help

Thank you, I underestand it but didnt want to have only option for 1/2 ticket to be multiplied by 2.. Thank you for your help.