half)
The formulas are array, so they're entered with Shift+Ctrl+Enter, which
automatically puts in the curley brackets and makes them work properly.
Regards - Dave.
> Subject: RE: $$Excel-Macros$$ Need help with a formula
> Date: Thu, 19 Aug 2010 21:40:38 -0400
> From: rebecca.mat
Thanks, Michael!
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Michael Hayes
Sent: Thursday, August 19, 2010 2:37 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Need help with a formula
Beckie or is it Becky
> ____________
>
> From: excel-macros@googlegroups.com
> [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack
> Sent: Thursday, August 19, 2010 12:27 AM
> To: excel-macros@googlegroups.com
> Subject: RE: $$Excel-Macros$$ Need help with a
-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Need help with a formula
Hi Becky,
If XL has put NA in a cell, you must already have a formula there.
You'll need to send a sample workbook so we can see get the whole
picture.
Regards - Dave.
> Date: Wed, 18 Aug 2010 12:15:30 -0700
&
As dave said, there is a formula in column
Click on the formula.
Carefully copy the formula except '=' symbol
type the following in the same cell.
=iserror(FORMULA, 0, FORMULA)
Replace the FORMULA with the copied formula
Regards,
Kishan Reddy, K
On Aug 19, 9:27 am, Dave Bonallack wrote:
> Hi
Hi Becky,
If XL has put NA in a cell, you must already have a formula there. You'll need
to send a sample workbook so we can see get the whole picture.
Regards - Dave.
> Date: Wed, 18 Aug 2010 12:15:30 -0700
> Subject: $$Excel-Macros$$ Need help with a formula
> From: rebecca.math...@kraft.co
