adding to formula revised

**Crasher** · 10-15-2006, 01:19 PM

can anyone help please

**oldchippy** · 10-15-2006, 01:20 PM

Can't open the zip file, Excel doesn't recognise it????

**Crasher** · 10-15-2006, 02:08 PM

try it this time

**Crasher** · 10-16-2006, 02:12 AM

some one must be able to help surely

**oldchippy** · 10-16-2006, 03:52 AM

Originally Posted by Crasher

try it this time

Still can't open it. What is an .xlsx file?

**Bryan Hessey** · 10-16-2006, 04:14 AM

Originally Posted by oldchippy

Still can't open it. What is an .xlsx file?

Hi oldchippy, it's an Excel Microsoft Office Open XML Format Spreadsheet file (http://filext.com/detaillist.php?extdetail=XLSX)

Crasher, when you open this file, what are your 'Save As' options?
---

**mangesh_yadav** · 10-16-2006, 11:45 AM

Do you want to add it manually or automatically through some code.
If you want it to add manually, then do the following:

In the formula in cell N9, add the part
-(Q10:Q11)
just before the last bracket to avoid #VALUE

Mangesh