Less than values equal zero

Question

If I have a column of data that contains actual values above 0.03 or says "<0.03" , how do I assign 0 for the less than values when calculating a formula in the next column?

In other words if:

Cell C1  formula =A1*B1*8.34, If value in B says "<0.03" assign 0 to B value in the column C formula or use actual number if greater than 0.03

Thanks

Answer 1

Hi,

I feel Connor's formula needs a slight change.

Use the following formula in cell C1 and check if meets your requirement.

Formula in cell C1    =A1*8.34*if(B1<0.03,0,B1)

Hope this helps.

Answer 2

For your cell C1 formula:

=A1*8.34*if(isnumber(B1),B1,0)

This will substitute 0 for any value (including but not limited to "<0.03") that is not a number in cell B1, which should fit your purposes if I understand right that "<0.03" is your only special non-numeric case.  Otherwise the condition in the if statement could be made more specific.