referring to numbers in other sheets

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

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
 
Something like this:

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

Hope this helps.

Pete
 
Back
Top