About Us

Pippa

I've put in this formula into Excel =IF(AA4+AG4="","",AA4+AG4) where the
cells AA4 and AG4 are blank and I require a blank cell as a result, this will
be copied into hundreds of other cells, however i get an error #value result.
Any suggestions?

Brad

=IF(AND(ISBLANK(AA4),ISBLANK(AG4)),"",AA4+AG4)
--
Wag more, bark less

"Pippa" wrote:

I've put in this formula into Excel =IF(AA4+AG4="","",AA4+AG4) where the
cells AA4 and AG4 are blank and I require a blank cell as a result, this will
be copied into hundreds of other cells, however i get an error #value result.
Any suggestions?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if statements	SB777	Excel Worksheet Functions	3	April 13th 07 06:42 PM
IF Statements (Mutliple Statements)	Deezel	Excel Worksheet Functions	3	October 19th 06 06:13 AM
using if statements	LAybar	Excel Worksheet Functions	4	March 20th 06 02:55 PM
if statements	qwerty_2006	Excel Worksheet Functions	3	March 12th 06 08:09 AM
IF and OR statements	Loraloo	Excel Discussion (Misc queries)	3	March 4th 06 11:42 PM

Menu

About Us