x
Solved

# What is the equivalent?

Posted on 2014-03-26
Medium Priority
280 Views
Hi All,

Suppose we have the following script:

(1)     "= if(constants!AO" & i & ">constants!AM" & i & ", 1, 0)"

which of course, in lay terms, is just putting in the formula

(2)      =if((constantsAO + row))>(constantsAM + row), then 1, else 0))

how would I do the reverse to get this starting with, in lay man terms:

(2)       = Round((constantsAO + row), AP),

....where in the column AP there is the corresponding list of significant digits, relevant to the correct row.

Wondering how to get this back into form (1).

(1) = ?

Is there also a way to get it into this form as well?

(1b) = constants.cells(i, "AO").formula?          {I know I butchered that, pls be kind}.

thanks!!
0
Question by:BostonBob
• 2

LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 39958016

.formular1c1="= Round((constants!RC41), RC42)"

with the R1C1 notation, you don't need to specify a row number as it's relative addressing (see more info here)

"= Round(constants!AO" & i & ",constants!AP" & i & ")"

Thomas
0

Author Comment

ID: 39958036
thanks for that!

I am going to have a number of these little script issues to tackle so please keep me on your radar for easy points!
0

LVL 39

Expert Comment

ID: 39958038

Thomas
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.