VBA functions & Arguments

Ok, so I have the 2 equations: A = 18000 + 500x
b = 22000 + 500y + 1000

x are values on range b2:b11 & y are values on c2:c11
the results will be on d2:d11

For this function I need to calculate the first equation with range b2:b12 and x has to be an argument

I need the same function for the second equation but my main concern is to set up the final function which decides which equation to calculate. If Y > 0 then I need the final function to use equation B. So if b2 has a x-value of 5 and c2 has a y-value of 2 I would use equation B and the output would be in D2.

Any help is appreciated. I am looking through the site trying to figure it out step by step but any help is appreciated!

First post/Thread!! Hello everyone!!

What if Y<=0?

y cannot be 0

So Y will always be >0 and equation B will always be used?

There should be no negative numbers

Sorry for being thick here but if there are no negative numbers doesn't that mean that you will always use formula B and the criteria Y>0 is redundant?

Also, if the results from from both formulas are to go in D2:D11 I can't see how it'll work.

Sorry, I didn't explain the scenario thoroughly. Equation b should only be used if y is any number other than 0.

How would I go about referring to the cells and having the proper equation calculate it?

How would I go about referring to the cells and having the proper equation calculate it?

The formulas are simple.

For formula A it would be:

=18000 + 500*B2

For formula B it would be:

=2300 + 500*C2

You would copy both formulas down for all the values in column B/C.

This looks slightly different to the original question.

Anyway, I do get an error with that code but not the one you describe.

The error I get is in the function getPredictedSalary and it's Variable not defined with InputYearManager highlighted.

If I change InputYearManager to ManagerYear I then get the error you describe.

The error is because you aren't passign any arguments to the functions getManagerSalary or getBaristaSalary.

If I change the function to this then it works.

Please Login or Register  to view this content.

There was another problem with overflow errors so I changed the declarations throughout the code from Integer to Long.

This is what I ended up with.

Please Login or Register  to view this content.

You are my savior Norie! Thanks for the quick reply!

One more thing. I need to allow decimals as inputs for the years. What do I need to change?

Originally Posted by protonLeah

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please! edit post #11. It must look like #12.

Done! Sorry about that

How can I change the code to allow decimals (such as 4.5) to be allowed as inputs. Now it just rounds the solution when a decimal is the input.

Nevermind, got it! Just changed few things to double