Posted to microsoft.public.excel.programming

[email protected] pignataro1@cox.net is offline

external usenet poster

Posts: 21

ERROR problem with Formula

Hi,
Still having an issue-formula reads:

=IF(AND('Pietra Majella DI'!$I$34<"",'Pietra Majella Ware'!$I
$34<""),"ERROR",DI&WARE)

But ERROR is the message I'm getting even though there is only 1 cell
that has info. It should be reading 2-error should only come up if
both Ware and DI cells are filled by mistake.

Anyone have suggestions?

Thanks

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Worksheet Functions	1	May 3rd 08 02:35 PM
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable	Enda80	Excel Discussion (Misc queries)	1	May 3rd 08 10:52 AM
ERROR.TYPE formula problem	tuph	Excel Worksheet Functions	3	May 25th 06 02:06 AM
Link page formula error problem	jimtmcdaniels	Excel Programming	2	May 22nd 06 08:59 AM
Unknown where is the problem on the Runtime error - Automation error	wellie	Excel Programming	1	July 10th 03 08:12 AM

All times are GMT +1. The time now is 04:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us