first time attempting to create a macro with a variable formula

**Sunjester** · 08-18-2019, 08:27 PM

Hello,

I'm attempting to create a macro with a variable and am having trouble with the formula.

Calculate the sum of two cells where:

1) Nodes 1-20 = $10,000
2) Every additional 10 nodes = $1,000 (e.g. 21-30 nodes = $1,000, 31-40 nodes = $1,000, etc.)

Thanks in advance.

**:) Sixthsense :)** · 08-19-2019, 12:41 AM

Using Formula

Please Login or Register  to view this content.

Using VBA

Please Login or Register  to view this content.

**Sunjester** · 08-19-2019, 12:49 PM

Thank you, that solved my issue.

first time attempting to create a macro with a variable formula

LinkBack

Thread Tools

Rate This Thread

Display

first time attempting to create a macro with a variable formula

Re: first time attempting to create a macro with a variable formula

Re: first time attempting to create a macro with a variable formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to create PivotTable errors out with run-time error 91 object variable not set

Attempting to Create an If Function

Attempting to create macro that finds a value and then transposes that row to a column

Attempting Macro to hide current tabs and create new ones with same info (Diff tab name)

Attempting to create a formula/code to have excel automatically move a column over

Attempting to pull a variable into another sheet dependend on drop down list

attempting to automate an import with variable data

Bookmarks

Bookmarks

Posting Permissions