I want a formula to ignore text eg 5mts * 5 ignoring the mts any .

  • Thread starter Thread starter Guest
  • Start date Start date
Two ways for the example posted:

You could try something like this:
=LEFT(I11,1)*I12
If 5mts is in I11 and 5 is in I12

You may also want to consider using a Custom Number format that would put
the mts into the cell instead of typing it manually.
Something like:
General"mts"

tj
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignoring Text in a formula 2
Drag formula - ignore blank cells 1
creating formulas which ignore text in the relevant cells 3
getting formulas to ignore text 4
Ignore blank celss in left function 2
Ignore text but count values in same cell 2
macro ignore formulas 3
ignore #n/a 2

Back
Top