Use the number part

  • Thread starter Thread starter Rudy
  • Start date Start date
R

Rudy

Sometimes I have data which I enter as : <0.05
How do I get Excel to use the cell's entry as 0.05 for further calculations?
 
Sometimes I have data which I enter as : <0.05
How do I get Excel to use the cell's entry as 0.05 for further calculations?
Click to expand...

When in A1, maybe...

=VALUE(MID(A1,2,255))

Ken Johnson
 
If Say you wanted to add it to the value in D4 then try:

=D4+(--SUBSTITUTE(D12,"<",""))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Just to add to Sandy's reply...

Since his formula is using the addition operator (or any arithmetic operator),
the -- stuff isn't necessary.

=D4+SUBSTITUTE(D12,"<","")
should work ok.
 
Back
Top