Why would the evaluate formula give the wrong result with the correct values?
In the evaluate formula window of Excel I get the final following steps.
370+27.5*(9.5)
370+27.5*9.5
370+261.25
4,725
The result should be 631.25; not 4,725 but I cannot figure out why it is adding incorrectly.
This exact same formula works fine in another workbook; this is from a template we use everyday that has never had this issue before.
Excel 2010; windows 7.
This is from a Vlookup+Vlookup*Vlookup which the final steps are all returning correct values. But the final result is wrong. Any ideas?