I am trying to set it up so that depending on the value of W2 it will
return .00075, .005, or .003:

=IF(AND(W21095=TRUE,W2<1461=TRUE),
0.00075),IF(AND(W21500=TRUE,W2<2000=TRUE),
0.005),IF(AND(W22500=TRUE,W2<3000=TRUE),0.003)

I get a #VALUE! error.

Thanks!!

What this does is takes a value in another cell that represents the
difference between two dates and then calculates the payment ratio.
I'd love to incorporate the entire formula into one cell but the task
seems daunting so I use a helper column.