My problem is, I am trying to create a compound interest formula in Excel that will calculate daily interest of 1.5% interest for 90 days.
So if I put in $500.00, the first day interest on 1.5 will be, $7.5, now that needs to go back into the total making it $507.50 and recalculated again for day two, and that total will be $515.11 and so on for 90 days. Hope I am making sense, I have an understand of Excel basics, just haven't used it in a couple years.

Thanks in advanced for any help and direction.

Meechy