Seems like a simple thing...I have tried to nest If statements (I have seen examples on the web) but it doesn't seem to like it. If I put and "End IF" between every statement it likes it...Here it is as I have it nested. I can just do it the other day but it bothers me when I can't find out why it's no good.
Code:If Salesamount > 0 And Salesamount <= 5000 Then Salesamount = Salesamount * 0.01 If Salesamount > 5000 And Salesamount <= 10000 Then Salesamount = Salesamount * 0.03 If Salesamount > 10000 Then Salesamount = Salesamount * 0.07 End If




Here it is as I have it nested. I can just do it the other day but it bothers me when I can't find out why it's no good.
Reply With Quote