If statement

[dabrows]

Need some help..I am a VBA noob- please excuse the ignorance.

I am trying to run loop solver w/ an if statement within the loop. Basically I want solver to solve for the solution then cross reference to make sure that the amount is available in the RRSP account [col b]. Right now I notice that solver can not find solutions to all of the cells in the loop. [i.e ignoring the desired if statement that i have attempted and failed miserably at]

If the amount isn;t available then deplete the RRSP account and add whatever the person couldn;t withdraw from the RRSP account to the withdrawal from the non rrsp account. And vice versa, same if statement for the Non rrsp account.

[but I don;t think that the second if statement is necessary b/c Total withdrawal=rrsp+non rrsp+taxes and i can work backward for the non rrsp amount]

suggestions/help would be MUCH appreciated.

[dabrows]

desperate here ppl- can anyone help? PLEASE