View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
justme justme is offline
external usenet poster
 
Posts: 68
Default Formula for interest

I am sorry, I do not understand what you mean?

"Peo Sjoblom" wrote:

While you are correct that the SUM is obsolete the value error derives from
one or all
the values being text

--


Regards,


Peo Sjoblom

"Pyrite" wrote in message
...
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.