Can someone please give me a hand with this formula? I was working through an Excel guide from Egmont, specifically on page 34, trying to figure out how to get my final price to round a certain way. Basically, I want any result where the decimals are less than or equal to .50 to round down to the nearest whole number.$17, but if the decimal part is greater than .50, I want it to round up to the next integer.$33
The problem is, whenever I try to enter the specific formula provided in the book, Microsoft Excel keeps throwing an error at me, claiming it's invalid. Here is what the formula looks like:
=VALUE(INT((C5*1,1)*1,22)+IF(((C5*1,1)*1,22)-INT((C5*1,1)*1,22)<= .5, .05, .99))
I am almost certain there is a typo somewhere in the printed text, but I can't for the life of me figure out where they messed up.
To break it down for you, the 1.1 represents a 10% markup, and the 1.22 is the old sales tax rate.
What I am actually trying to achieve is adding the base price plus the markup and sales tax, then adding an extra $0.17 if the difference between that total and its rounded version is less than or equal to 0.5. Otherwise, I want to tack on an additional 0.99.
Man, what a complete mess this is!
The problem is, whenever I try to enter the specific formula provided in the book, Microsoft Excel keeps throwing an error at me, claiming it's invalid. Here is what the formula looks like:
=VALUE(INT((C5*1,1)*1,22)+IF(((C5*1,1)*1,22)-INT((C5*1,1)*1,22)<= .5, .05, .99))
I am almost certain there is a typo somewhere in the printed text, but I can't for the life of me figure out where they messed up.
To break it down for you, the 1.1 represents a 10% markup, and the 1.22 is the old sales tax rate.
What I am actually trying to achieve is adding the base price plus the markup and sales tax, then adding an extra $0.17 if the difference between that total and its rounded version is less than or equal to 0.5. Otherwise, I want to tack on an additional 0.99.
Man, what a complete mess this is!