View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How would I enter this formula so it works. B3+C3-D3*E3 ?

Being all formulas with =, so you need =B3+C3-D3*E3
But we aware the multiplication happens first, so it finds = (B3+C3) -
(D3*E3)
If you want to add the two values, do the subtraction and then multiply, use
=(B3+C3-D3)*E3
best wishes
PS Please write Question in the white space
PPS The formula is the same no matter what cell you put it in
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Joey" wrote in message
...
This would be a formula for a ending balance in cell F3.