I see that you're using the MS web interface so in the list on the left side
select Excel Programming.

--
Biff
Microsoft Excel MVP


"Hijosdelongi" wrote in message
...
ahh ok, thank you so much.. and do happen to know where can go i that
forum?
do u know the link to that furom? thanks. =)

"T. Valko" wrote:

Hmmm....

I'm not sure. You might be able to do that with an event macro but I
don't
know how to do it.

Try posting this question in the programming forum. If A1 contains a
formula
make sure you note that in your question.

--
Biff
Microsoft Excel MVP


"Hijosdelongi" wrote in message
...
Hi, got a Question again... is there any formula that can automatically
create a comment in a cell?

ex.

A1 = 80% and can we have a comment on that, that automatically that
says
"Passed"

Thanks.

"T. Valko" wrote:

I have a question for Excel 2003
=AVERAGE(IF(AND($A2=Data!$B:$B,B$1=Data!$A:$A),Da ta!$C:$C,""))

You can't use entire columns as range references in array formulas in
Excel
2003. Use a smaller specific range.

Try it like this (array entered**)

=AVERAGE(IF((Data!A1:A10=B1)*(Data!B1:B10=A2),Data !C1:C10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the
SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Hijosdelongi" wrote in
message
...
Hi,

I have a question for Excel 2003

=AVERAGE(IF(AND($A2=Data!$B:$B,B$1=Data!$A:$A),Dat a!$C:$C,""))

Im trying to get the AVERAGE of this and its giving me a #VALUE!
error..
$A2
is the name that is suppose to be equal in the Data! worksheet and
B$1
is
the
date that is suppose to be equal in the Data! worksheet. Im trying
to
use
AND
in IF for me to have two logical test..

Can you help me with this?

Thank you so much!



"JE McGimpsey" wrote:

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF((A3:A45="Photo")*(H3:H45<""),H3:H45))

In article ,
"Spottkitty" wrote:

=AVERAGE(IF($A$3:$A$45="Photo",H3:H45))

This is the array I'm using to try to determine an average.
Problem...if
the field is blank it's counting it as zero and lowering the
results.
It
figured 79% when it should have been 94%. 94% was returned
using
the
simple
average formula. I'm guessing I need to nest something to not
count
nulls?
Help!!!