Search
Search

# Complex Formula - How to access other cells' data in a formula

Hello,

I'm trying to create a formula to classify some registers to A,B or C depending in a total value percentaje.

A = de 0 a 80

B = 80,01 a 90

C = 90,01 a 100

Example:

Name Value % %Sum Class

A 2000000 38% 38% A

B 1500000 28% 66% A

C 1000000 19% 85% B

D 800000 15% 100% C

Sum 5300000 100%

In web intelligence I can get to,

Name = (Name)

Value(\$) = (Value)

%s/total =Percentage((Value))

%Sum ?

Class ?

The way to calculate the %Acum is first to sort all the registers by rank and then you can calculate A, AB, ABC, ABCD (this can be done in Excel), but I don't know how you can access other cells' values from a single cell.

If I can do that, then I can do an if() formula that filter %Sum by a range (if(%Sum>90;"C";if(%Sum<80;"B";"C")). My problem is how can I calculate the column %Acum

Thanks & Regards

SU

Edited by: soauniverse on May 24, 2011 10:42 PM

##### Former Memberreplied

Use RunningSum([Object]) function to get the cumulative sum.

Regards,

Rohit

0 View this answer in context
View more on this topic or