Can I assume your sheet is set up like this?

John

Name Annual fee No of Payments 6/1 7/1 etc
tom 100 1 100
bob 100 2 50 50



-----Original Message-----
Howdy... new to VBA programming and I have a project in
front of
me.....

I am working on a spreadsheet to caculate payment for our
speedskating
association where most of the data is automated.

I would like to be able to extend my nested if's to also
include a
second if

eg. if date=june 6/04 & if no of payments=5 then
calculate the payments
this way... but if date=june 6/04 & no. of pay=1 then
have all the
money due on this date... or in 3 payments or 2
payments... and we have
it totalled to cross reference it for our VP of fiance
(how much should
be deposited on Oct 1 and number of items to be
deposited) [counta is
great]

in brief - people can take up to 5 months to pay the
fees - depending
on the date they register - July 1-Nov 1. Some people
prefer to pay all
up front though so the no. of payments =1 but we don't
want the default
payment to be on Nov 1 but rather on the date of the
registation or the
1st of the next month.

I took pascal training MANY moons ago so I understand the
If THEN ELSE
idea (just can'tr remember the syntax)... how can I set
up an IF and IF
THEN ELSE nested option?

Clear as mud?

Thanks in advance


---
Message posted from http://www.ExcelForum.com/

.