Use the number part

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rudy - 21 Dec 2007 10:49 GMT

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?

Reply to this Message

Ken Johnson - 21 Dec 2007 11:21 GMT

> 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?

When in A1, maybe...

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

Ken Johnson

Reply to this Message

Sandy Mann - 21 Dec 2007 11:35 GMT

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

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

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> 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?

Reply to this Message

Dave Peterson - 21 Dec 2007 14:33 GMT

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.

> If Say you wanted to add it to the value in D4 then try:
>
[quoted text clipped - 13 lines]
> > How do I get Excel to use the cell's entry as 0.05 for further
> > calculations?

Signature

Dave Peterson

Reply to this Message

CLR - 21 Dec 2007 14:05 GMT

One way.........

=SUBSTITUTE(A1,"<","")*1

Vaya con Dios,
Chuck, CABGx3

> 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?

Reply to this Message