Gary,
this works but need to and two more cells and ranges to this formula could
this be done

"Gary" wrote:

Mike" wrote in message
...

I'm trying to get a formula to be between two numbers. Is my * my problem


Try

=if(and(D43=45,D43<=87),"5.00","0.00")

is this what u need?