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)
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Hi,
Arthurbr has given you the answer, so just an observation.
Why would anyone buy 4 tickets when they can buy 5 for 3 euro less?
Regards
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
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.
In that case perhaps
=IF(A1<=4,"5 euros +"&5-A1&" bonus tickets",A1)
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks