Compare two columns to a third

[Chipper57]

Hello,

I am new to the board and not versed in Excel. I know how to make simple tables and simple calculations, but that is where my knowledge stops. I get into nothing but trouble past this point.


I want to know if A1+B1 is >= to C1 by the 11th day of the month then report $0.00 in D1. If A1+B1 is < C1 by the 11th day of the month then report $10.00 in D1. Now for the second part, if a A1+B1 is >= to C1+D1 by the 21th day of the month then report $0.00 in D1. If A1+B1 is < C1+D1 by the 21th day of the month then report $15.00 in E1.

This is way over my head. I'm not sure if this is going to involve a look up table or not.

If someone could help I would appreciate it.

Thanks,

Chipper

[FDibbins]

Hi and welcome to the forum

It would be easier to offer suggestions if we could see what you are working with, but lets give it a shot....

=if(day(today()=11,if(A1+B1>=C1,0,10)..................
for the 2nd part, I think you have your references wrong?
A1+B1 is >= to C1+D1 by the 21th day of the month then report $0.00 in D1...you cannot add C1+D1 IN D1, you will get a circular error.

Assuming you meant you want this in E1...
=if(day(today()=11,if(A1+B1>=C1+D1,0,15)

,if(day(today()=21,if(A1+B1>=C1,0,10),

[Chipper57]

What I am trying to accomplish is for columns "Q", "R" & "S" to auto fill. If "K" (Payment 1) + (Payment 2) doesn't equal or greater than the "I" (Total Rent Due) by the 11th day of the month then I want a fee of $10.00 to fill in column "Q" (11 Day Late Fee). On the 12th day I want a $15.00 to fill in column "R" (12th Over Lock Fee). If "K" (Payment 1) + (Payment 2) doesn't equal or greater than the "I" (Total Rent Due) by the 21th day of the month then I want a fee of $15.00 to fill in column "S" (21 Day Late Fee).

Storage Units.JPG

Thanks for taking time to help me.

[FDibbins]

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[Chipper57]

How do I upload a sample of my workbook?

[Chipper57]

I have attached my document.


Storage Unit Spread Sheet Test.xls

[Chipper57]

[QUOTE=FDibbins;3481286]Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)[have you had anymore time to look at my spread sheet? I tried to apply what you sugested, but it didn't work.]