Need help figuring out IF this, then that, etc.

[dotrain4u]

I need to know how to figure out if the number of days to pay (column M) is outside 45 to 89, then the value in column N should be "N" and the check amount should be added to the running total. If the number of days is within 45-89 (inclusive), then the value in column N should be a "Y" and the amount should NOT be added to the total, it would still equal the total in the cell above it. Please help! I know the example won't look good, but if you spread it out over columns you might be able to see.

L/ M/ N/ O/
Check Amount/ Days to Pay/ (45-89 )/ Running Total
250.00/ 172/ N/ 982/

 

[Gerald Higgins]

I think I know what you mean, but it's difficult to be certain.
Assuming your sample data is in the range L3:O3, with similar data above and below, I think this will work in O3

=O2+((N3="N")*L3)

If you need a formula for N3 as well . . .

=if(or(M3< 45,M3> 89),"N","Y")

Copy these formulas down as far as required.

 

[dotrain4u]

Thank you Gerald, with just the insertion of my cell references that worked perfectly! Thanks very much.