=if, then answer needs to be a number, not text

[tryingcake]

I need to run a formula similar to this:

=IF(C58<0.06, "2")

My issue is, it's reading the "2" as text. I need it to be a number than can be added to other numbers. I can't find the correct formula.

What do I need to do differently?

Thanks!

 

[kweaver]

Don't put quotes around the 2. What happens if C58>=0.06 ?

=IF(C58<0.06, 2, ???)

 

[tryingcake]

Don't put quotes around the 2. What happens if C58>=0.06 ?

=IF(C58<0.06, 2, ???)

It's a point system. If the overall score is less than .06, we get 2 points. If it's more than .06, we get 0 points.

 

[kweaver]

Then, try this:

=IF(C58<0.06, 2, 0)

Unless you mean <= which requires a change in the code.

 

[tryingcake]

Then, try this:

=IF(C58<0.06, 2, 0)

Unless you mean <= which requires a change in the code.

I'm sorry. You are right. It should be <=.