IF formula assistance

[ExcelDummy77]

I'm needing help with an IF formula:
If B37 is >=0 and <=45 then it equals cell B101.

I can post a coy of spreadsheet if needed.

Thanks in advance!

[ConneXionLost]

How about:

Please Login or Register  to view this content.

Cheers,

[ExcelDummy77]

This works for the true statement of equaling B101. However, the false statement isn't working. I still get the result of cell B101 if the statment is false.

Any ideas on how to correct?

[Speshul]

What value are you testing the false statement with?

Put a 50 in cell B37, and a 0 will return

It is saying if B37 = More than 0 but less than 45, then B101, otherwise 0. So a 46 or more returns a 0, and a -1 or less returns a 0

[ExcelDummy77]

It does work theoretically but my formula doesn't appear to work correctly. I'm attaching a sample of the spreadsheet to show exactly what I have and how the false statement doesn't populate.

It's based on Date/Time In and Task Performed Date/Time.