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
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