how to mirror a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ZenMasta - 08 Oct 2007 21:15 GMT

How can I make field A2 = AA2 when it's not a number?
=SUM(AA2) displays a zero.

Reply to this Message

Nick Hodge - 08 Oct 2007 21:43 GMT

ZenMasta

Don't use an aggregate function

=AA2

should do it

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog

> How can I make field A2 = AA2 when it's not a number?
> =SUM(AA2) displays a zero.

Reply to this Message

Trevor Shuttleworth - 08 Oct 2007 21:43 GMT

=AA2 ?

Regards

Trevor

> How can I make field A2 = AA2 when it's not a number?
> =SUM(AA2) displays a zero.

Reply to this Message

Rick Rothstein (MVP - VB) - 08 Oct 2007 21:46 GMT

> How can I make field A2 = AA2 when it's not a number?
> =SUM(AA2) displays a zero.

What about this?

=IF(ISTEXT(A16),A16,"")

Rick

Reply to this Message

Rick Rothstein (MVP - VB) - 08 Oct 2007 21:50 GMT

>> How can I make field A2 = AA2 when it's not a number?
>> =SUM(AA2) displays a zero.
>
> What about this?
>
> =IF(ISTEXT(A16),A16,"")

Of course that should be...

=IF(ISTEXT(AA2),AA2,"")

Rick

Reply to this Message

ZenMasta - 08 Oct 2007 22:06 GMT

Thanks, I don't use excel much and 99% of what I was doing was multiplying
and adding multiple fields per row and I didn't even think to use the equal
sign and field name. :P

> How can I make field A2 = AA2 when it's not a number?
> =SUM(AA2) displays a zero.

Reply to this Message

Tyro - 08 Oct 2007 22:40 GMT

If you simply use =AA2, if AA2 is empty, you'll have a 0 in the cell where
you put the formula

=IF(AA2="","",AA2)

> How can I make field A2 = AA2 when it's not a number?
> =SUM(AA2) displays a zero.

Reply to this Message

Tyro - 08 Oct 2007 22:54 GMT

Sorry misread, you said when it's not a number. Put this formula in A2:

=IF(AA2<>"",IF(NOT(ISNUMBER(AA2)),AA2,""),"")

If AA2 is not empty and AA2 is not a number A2 will equal AA2.

Tyro

> How can I make field A2 = AA2 when it's not a number?
> =SUM(AA2) displays a zero.

Reply to this Message

Rate this thread: