Can't get rate function to work

Did you try writing your Rate function by selecting 'Insert' then 'Function' from the Excel menu ?

This brings up the wizard which explains all the info required to make the formula work properly.

If you have then post a few more details or an example and you'll get a few solutions for sure.