C
cfiser
I am trying to add percentage numbers and it is rounding up/down...Is there
any way to stop the rounding.
example
CELL C36 CELL D36 CELL E36
ACTUAL # =C36*(1-20%) =C36*(1-80%)
$169.82 $135.86 $33.96
$775.81 $620.65 $155.16
$945.63 $756.50 $189.13
WHEN I USE A BASIC ADDITION DOWN EACH COLUMN, I GET NUMBERS ROUNDED DOWN IN
COLUMN D AND NUMBERS ROUNDING UP IN COLUMN E. IS THERE ANY WAY TO GET THE
ACTUAL NUMBER.
THANK YOU
any way to stop the rounding.
example
CELL C36 CELL D36 CELL E36
ACTUAL # =C36*(1-20%) =C36*(1-80%)
$169.82 $135.86 $33.96
$775.81 $620.65 $155.16
$945.63 $756.50 $189.13
WHEN I USE A BASIC ADDITION DOWN EACH COLUMN, I GET NUMBERS ROUNDED DOWN IN
COLUMN D AND NUMBERS ROUNDING UP IN COLUMN E. IS THERE ANY WAY TO GET THE
ACTUAL NUMBER.
THANK YOU