Solved

# Translation of an excel formula to Oracle SQL

Posted on 2014-02-28

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.