View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pyrite Pyrite is offline
external usenet poster
 
Posts: 78
Default Formula for interest

Depending on what you are trying to achieve there is probably an easier way
but to answer you exact question you could use:

=(((A1*B1)/C1)*D1)

"justme" wrote:

I want to take (a) times (b) divide by (c) and multiply by (d)

I did =SUM(A2*A3/A1*A4) and I get a #VALUE in my cell. What am I doing wrong?

Thank you so much.