Cell Ref with Formula not returning result in new IF Formula

[ejackson37]

Hi,

If anyone can help with this it would be greatly appreciated.

The excel formula I have created to return today's date in G2 if A2 is between 100-109 is not returning the result even though A2 is 103.

I think this is because A2 is an'=' reference from another sheet.

Does anyone know how to get excel to return result based on a reference from another sheet?

Formula in G2 is: =IF(AND(A2>=100,A2<=109),TODAY(),"")

Formula works if I copy cells and paste values & convert to number but I'd like it to work with reference so I don't have to do this for every report

 

[Joe4]

Welcome to the Board!

It is because your numbers are entered as Text and not number (notice how they are left-justified in the cells? that is usually a dead give-away).

You need to convert those entries to numbers. You can coerce them to numbers by adding "+0" to the end of your reference formula in column A, i.e.

=reference + 0

 

[ejackson37]

Welcome to the Board!

It is because your numbers are entered as Text and not number (notice how they are left-justified in the cells? that is usually a dead give-away).

You need to convert those entries to numbers. You can coerce them to numbers by adding "+0" to the end of your reference formula in column A, i.e.

=reference + 0

Excellent, seems to have fixed it. Thank you very much! Great community

 

[Joe4]

You are welcome.
Glad I was able to help!