Thank you for a wonderful site. I find it useful every day!
My question has to do with product price rounding. I would like all prices to end in either 4.95 or 9.95. I need a formula(?) to look at the first digit to the left of the decimal. So if a product's last digit is 0-4 it would round up to 4.95. For example $1 (rounded to 4.95) or $212 (rounded to 214.95). If the last digit is 5-9 it would round up to 9.95. For example $16 (19.95) or $1,858 (1,859.95).
I hope I made that as clear as possible. I haven't been able to put together any combination of formulas in order to look at the first digit to the left of the decimal.
I appreciate any help
My question has to do with product price rounding. I would like all prices to end in either 4.95 or 9.95. I need a formula(?) to look at the first digit to the left of the decimal. So if a product's last digit is 0-4 it would round up to 4.95. For example $1 (rounded to 4.95) or $212 (rounded to 214.95). If the last digit is 5-9 it would round up to 9.95. For example $16 (19.95) or $1,858 (1,859.95).
I hope I made that as clear as possible. I haven't been able to put together any combination of formulas in order to look at the first digit to the left of the decimal.
I appreciate any help
