open office

[george1963]

hi i am trying to do batch calculations in open office calc, i have 200+ figures in row a and want to subtract 2.083333% from them how do i do it

[renegade600]

from each figure or the sum of the row

[george1963]

i want to subtract the 2.0833335 FROM THE WHOLE LOT
FOR INNSTANCE IF I HAVE A FIGURE OF £120 AND WANT TO SUBTRACT THE CALCULATION I WOULD DO ON A CALCULATOR WOULD BE 120.00 *2.083333% - = GIVING ME A FIGURE OF £117.50
WHEN TRYING THIS IN OPEN OFFICE CALC THE FIGURE IT GIVES ME IS 2.49996

[renegade600]

try this =E5-(E5*0.028333) there are other ways to do it also.

the e5 represents the cell where the number you want to change is.

[george1963]

Thanks That Seems To Work