Solved

# What is the equivalent?

Posted on 2014-03-26
271 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 500 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.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…