Z
ZenMasta
How can I make field A2 = AA2 when it's not a number?
=SUM(AA2) displays a zero.
=SUM(AA2) displays a zero.
N
Nick Hodge
ZenMasta
Don't use an aggregate function
=AA2
should do it
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
Don't use an aggregate function
=AA2
should do it
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
T
Trevor Shuttleworth
=AA2 ?
Regards
Trevor
Regards
Trevor
R
Rick Rothstein \(MVP - VB\)
How can I make field A2 = AA2 when it's not a number?
What about this?
=IF(ISTEXT(A16),A16,"")
Rick
What about this?
=IF(ISTEXT(A16),A16,"")
Rick
R
Rick Rothstein \(MVP - VB\)
How can I make field A2 = AA2 when it's not a number?
Of course that should be...
=IF(ISTEXT(AA2),AA2,"")
Rick
Of course that should be...
=IF(ISTEXT(AA2),AA2,"")
Rick
Z
ZenMasta
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.
and adding multiple fields per row and I didn't even think to use the equal
sign and field name.
T
Tyro
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)
you put the formula
=IF(AA2="","",AA2)
T
Tyro
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
=IF(AA2<>"",IF(NOT(ISNUMBER(AA2)),AA2,""),"")
If AA2 is not empty and AA2 is not a number A2 will equal AA2.
Tyro