Excel Query

[Saviola]

Heya,

Just a quick query. I know there is a way t do it but my brain is hurting at the moment so does anyone know how to do the following:

I have various columns with figures in, but I need to reduce some by 50% and others 25%. Is there a formaula I can use to do this without adding more columns/rows?

sum=(A1*0.5) will not work as its circular.

Any help welcome as my brain will explode today

Cheers
Saviola

 

[div0]

(As far as I know) There is no formula that can edit the value of its own cell - which, by the sounds of things, is what you're asking. You'll create a circular reference every time.

Just create new columns and then hide the old ones if you don't need them.

 

[Saviola]

Yeah cool thats what I am doing. Just wante to double check with the experts

Cheers
Saviola