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!!