How to measure values of an equations with two variables and save each on a different Cell

So I have the equation BGain=1500 + 2800(5 - Y) + 500X - 500Y
where X is from 0 to 5 and why is from 0 to 5
I want the values to be calculated through a macro then output each under a column in a different row.
is it possible?

Something like this?

Please Login or Register  to view this content.