asked on

how to multiply two cells in a (relative) column

Hi All,

Today I would like to know how to multiply two scenarios:

1 = if((evaluate(Worksheets("Tickets").Cells(r1, "A").value * Worksheets("Tickets").Cells(r1, "B").value) < evaluate(worksheets("OtherSheets").cells(r1, "D")), 1, 0)
2 = if((evaluate(Worksheets("Tickers").Cells(r1, "A").value * Worksheets("OtherSheet").cells($d$1).value) < evaluate(worksheets("thisSheet")$e$1)

'not sure if I have the .cells($d$1) & $e$1 notation right to begin with, in fact I am pretty certain it is butchered and good.

so I would like to know how to write this so that I can do two things:

1. Write the formulas and "get them ready" to evaluate and get a number (for each formula.)
2. Put the formulas in and have them evaluate, and just get a number and skip the formula (for each formula.)

Does that make sense?

aikimark

Does r1 refer to row 1 or is this a variable in your routine?

I'm not sure what you mean by "get them ready".

Are you trying to replace formulas with values in your worksheet?

I'm used to seeing worksheet formulas that look simpler:

=IF((Tickets!A3*Tickets!B3)<OtherSheet!D3,1,0)

Open in new window

=IF((Tickets!RC[-4]*Tickets!RC[-3])<OtherSheet!RC[-1],1,0)

Open in new window

ASKER CERTIFIED SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BostonBob

ASKER

I will run with that today Saqib....I think that is what I want. let me put it in and test it! THANKS!

BostonBob

ASKER

OK that works. Now how do I get it into this kind of form for both equations above?

"= If(quotes!V" & i & ">Constants!AK" & i & ", 1, 0)"

....where we are "pasting in" the formula?

thanks!