Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
1) I have a formulae in a cell but no corresponding value in £'s
I have a formulae as =Sum(H3:H6) in a cell which should display a value in
currency. No value is seen, but the grand total displayed at the end of the sheet, including many other formulae ( shown in local currency ) includes the missing items. Also, how do you lock formulae without proctecting the whole sheet? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
1) I have a formulae in a cell but no corresponding value in £'s
Hi, maybe your calculation is set as manual, go to
TOOLS|OPTIONS|CALCULATION|AUTOMATIC Regarding to lock formulae, this is not possible, the way to do it is unlock all cells of the spreadsheet, lock the formulas and protect it, so you just have protected the formula ranges. hope it helps Regards from Brazil Marcelo "Michael" escreveu: I have a formulae as =Sum(H3:H6) in a cell which should display a value in currency. No value is seen, but the grand total displayed at the end of the sheet, including many other formulae ( shown in local currency ) includes the missing items. Also, how do you lock formulae without proctecting the whole sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Can you have fixed cell reference when dragging/copying formulae? | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |