Adjusting an IF formula

A1 is the date
The late fee or $75-$190 would be in cell D1
Wouldn't that be an IF formula?

Is A1 in an actual Date format? Since you are assigning late fees, it seems that you will need to first use two date fields to find out how many days late the item is. Then and only then could you write a formula. Also be aware that you cannot use a formula in one cell to increment the value of another cell. In other words you cannot just keep adding to an existing value based on an if condition. You can only have the value of the cell change based on the state of another cell to another value. Once you have the number of days... JBeaucaire's formula =MIN(35+(A1*10), 190) is elegant and will work.

so, I think I understand what you are saying....
I would need to add a cell with like say 5 in it saying that they are five days late, then in the late fees cell, your formula would work?

Is this what you are looking for =IF(NOW()-A1>=5,MIN(35+(FLOOR(NOW()-A1,1)*10), 190),)

Adding the extra column of dates as required in JBeaucaire response is the better way to go.

Okay, here is my work book...
If they pay on the 4th, we need to add $75.00 in late fee column
If they pay on the 5th, we need to add $85.00 in late fee column
If they pay on the 6th, add $95.00 and so on, adding $10.00 per day up to $190.00

Please help...
Thank you all so much!!

I tried what you said, but no matter what date I put in, it automatically added $190.00...please help?
Oh, and on my spreadsheet,
the due date is cell B19
The date paid is cell C19
and the late fee is in I19
Thank you for all your help....I really need this for my boss, she is counting on me

okay, I put it in...thank you so very much!!

And here it is with the formula...I'm sorry

Unfortunately you didn't put in your formula as requested by JBeaucaire however to save subsequent frustration
Change your headings as directed to
RECEIPT NUMBER Due Paid

Your problem appears to be your test date at B21 is 1/01/1900 and your date at C21 is 4/01/2013 (Needs more than your Max fee of $190)
Formula at I21 is =IF(AND(COUNT(B21:C21)=2, C21>B21, C21-B21>3), MIN(35+((C21-B21)*10), 190), "")

OKAY, I changed what you said, and put the formula in...please help? It is still not working

It appears to work fine for me when I put in proper dates into B21 and C21 (You have no's 1 and 4 in your supplied sheet)

Tiger, how did you do the date? 02/01/13 or 02/01?

Yes, it works!! the only problem is that on the 4th it should say $75.00 and then go up each day by $10.00 to $190.00 and it only works with the 5th and up

B21 is 02/01/13
C21 is 02/04/13

Thank you so very much!! That works!!

Yes I was about to suggest the same formula changes as in daddylonglegs if you are counting the 4 as the 4th day. The formula till now has been after 4 clear days the fees start on the 5th day.

I'm hoping that I can ask another question. The formula that I got off here on the I cells is correct, the only problem is, if they don't have a late fee, I have to put a 0 in the cell to carry it over to the balance or M and N cells. When I put the 0 in, the formula goes away and therefore when the sheet is full, I have to re-enter the formula. I hope this makes sense. If they do not owe any late fee and pay before the 4th, is there a way to tweak the formula so that we don't have to enter anything in the I cell and the formula stays intact?

I tried it and it didn't work...I copied and pasted your formula but it doesn't work for me. Maybe I am doing something wrong?

I don't want to sound stupid, but I don't understand. What are flags?

If they pay before the 4th, there will not be any late fees, therefore the I column would be blank. I would like it to stay blank and then add across as long as they pay before the 4th

I am in the process of trying to find some good online classes in advanced excel. It is so hard to know which ones are good classes and which ones aren't.

I am not sure that I understand what you are trying to tell me, but right now, the formula that you gave me a while back works as far as figuring in the late fee and it works wonderfully....but if they pay before the late fee kicks in, it makes me put 0.00 in the cell for the late fee in order to add across (otherwise, it just says #value!). By putting the 0.00 in the cell, it deletes my formula and when the page gets full, I have to go back and add the formula for the late fee again. This is not a problem for me, but they are wanting me to share this worksheet with many other offices and it might be for them. Therefore, I thought that there might be a formula for the current balance cell that would add up the row without anything in the late fee cell. Therefore, I guess I am asking for a formula for cell N that will add across without there being a late fee in the late fee cell.

I hope this makes sense

Okay, thank you so much. See if there isn't a late fee, then it won't go across. I'm sorry, I thought I had put in a worksheet. But on the third and fourth line, there isn't a late fee, so it won't add across, unless I put in 0.00 and that erases our wonderful formula
Thank you so much

I inserted the wrong worksheet...but I'm sure you get the idea..but here is another one that actually shows them paying on time and it not going across
Thank you again

Since JBeaucaire isn't on line at the moment, have a try changing his Late Fee formula to:

=IF(AND(COUNT(B21:C21)=2,C21-B21>2),MIN(45+(C21-B21)*10,190),0)

Thank you for acceptance but now it's laurabach who is no longer online .

That worked perfect. You guys are wonderful!!!!