First off, why use strings to specify a numeric (Double) value for interest?
I learned VBA a while ago, but I think that
If 1000000 < loan < 4000000 Then interest = .10
is invalid syntax. Try
If (1000000 < loan) and (loan < 4000000) Then interest = .10
Or, you might try
interest = 0.10
If loan < 1000000 Then interest = .08
If loan > 4000000 Then interest = .11
That is, assume the interest will be .10, and only change it if the loan amount is too big or too small
Or, if you find that you have to do other stuff depending on the interest rate, you could go whole-hog and say
If loan < 1000000 Then
interest = .08
do 8% stuff
Else If loan > 4000000 Then
interest = .11
do 11% stuff
interest = .10
do 10% stuff
Computer Programming - I'm trying to create a vba code that solves this problem...
Computer Information - A __________ provides the tools that a programmer uses to...
Computer science - THIS IS C PROGRAMMING I NEED TO CREATE A METHOD! Create a ...
programming - create a program that prompts the user for a number the returns ...
Programming (CSI Programming Logic and Design) - Create a program that outputs a...
Programming (CSI 150 Programming Logic and Design) - Create a program that ...
VBA EXCEL - I was wondering I have 3 input boxes and with one of them I need the...
programming - create a program that solves the area of a rectangle
programming - Given a = 5, b=1, x=10, and y =5, create aprogram that outputs the...
Programming Java - I have to create an analog clock..What methods should i use