I have a field that is dividing a decimal (currency) in 1/2, but when it puts the answer in the field, it is rounding to the whole number.
Example:
566.33 in inputed and is supposed to be divided in half in the next cell, but the answer that displays is 283.00.
I already have the formula in the cell to divide, so how do I fix this to also not round the digit to the whole number but to round it to the second decimal place value?
Thanks!
Jerome Benton
JERPAT Web Designs
GOD Is Good All The Time!!!
Example:
566.33 in inputed and is supposed to be divided in half in the next cell, but the answer that displays is 283.00.
I already have the formula in the cell to divide, so how do I fix this to also not round the digit to the whole number but to round it to the second decimal place value?
Thanks!
Jerome Benton
JERPAT Web Designs
GOD Is Good All The Time!!!