I am trying to convert an excel formula into oracle sql. The excel formula is straight forward for the most part.

However, there is a portion of the formula I can not understand and so can not interpret.

Assume:

C3 = 2

D3 = 32

E3 = 28

F3 = 24

G3 = 18

H3 = 0

L3 contains the following formula: {=C$3^(D$3:G$3)}

What is this formula doing? I thought it was 2 to the power of the sum of D3-G3, i.e. 2^102

Therefore I wrote POWER(2,102). But based on the expected result for the entire formula, it is not.

Help will be appreciated.

With your data and Excel 2007, it generates an error for me.