modifing your formula
=IF(AND(W21095,W2<1461),0.00075,IF(AND(W21500,W2 <2000),0.005,IF(AND(W22500,W2<3000),0.003,"")))

There are alot of numbers that you don't specify what the value should be.

The above equation will make the cell blank for these other numbers...
--
Wag more, bark less


" wrote:

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.