| 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? |
| 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 | |||
Threaded Mode
