calculations off

Hi, looking for a bit of advice. i have a built spreadsheet where i am calculating the cost of a product based on other factors. To give an example: A1) 2.21 >>>>entered manually A2)=A1 >>>> (so shows 2.21) A3)=ROUND(SUM(35/B11),2) >>>> to explain, this is taking a figure of 35, then...

Hi guys, for some reason, in vba, i made the formula to capture data from 2 cells to the left and turn green if its greater or equal, and red if its less than. but it always shows cell E2 when i open the manage rules section. it also gives me one wrong value for some reason. one cell is 99.93%...

I am trying to stop calculations in a single workbook while maintaining calaculations on in another workbook. I have the workbooks set up to run set calculations when different parameter change but haveing calculations constantly running on one of the workbooks locks Excel for 15 to 20 minutes...