Ask a questionAsk a question
 

QuestionMicrosoft Excel adding face value

  • Wednesday, September 02, 2009 6:12 PMsnowmanrx Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I have built a calculator for my business that involves some multiplication with decimals. I then have formatted the cells to show only 2 places after the decimal point forcing it to round. My question is, for the information I need, I need to be able to add the face value of cells that I specify. I have tried forcing the sheet to everything for face value and that does not calculate correctly. How do I go about selecting which cells to force face value to?