referring to numbers in other sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.baker13@googlemail.com - 13 Nov 2007 19:18 GMT

Hi

I have a spreadsheet with a formula that looks at another sheet
=(Original!C56)

Most items here are numbers i.e.

120257577

but there are a couple of text entries i.e.

bowl off

How do I get the formula =(Original!C56)to recognise and pull across
the numbers but ignore the text entries.

Ta

Brian

Reply to this Message

Pete_UK - 13 Nov 2007 19:29 GMT

Something like this:

=IF(ISTEXT(Original!C56),"",Original!C56)
or
=IF(ISNUMBER(Original!56),Original!C56,"")

Hope this helps.

Pete

On Nov 13, 7:18 pm, "brian.bake...@googlemail.com"
<brian.bake...@googlemail.com> wrote:

> Hi
>
[quoted text clipped - 15 lines]
>
> Brian

Reply to this Message