I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I really
appreciate any help.

Thanks,
Heidi

Congrats on the new job!!

=IF(Day(A2)=26,86.72,0)

Assuming the due date is the same for everyone?

this would enter $0 if not late...

"Needing help at new job" wrote:

I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I really
appreciate any help.

Thanks,
Heidi

Try one of these:

To return either the late fee or 0:

=(DAY(A1)=26)*86.72

To return either the late fee or a blank:

=IF(DAY(A1)=26,86.72,"")

--
Biff
Microsoft Excel MVP


"Needing help at new job"
wrote in message ...
I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to
do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I
really
appreciate any help.

Thanks,
Heidi

Thank you so Much!!! You made it look easy LOL

"Sean Timmons" wrote:

Congrats on the new job!!

=IF(Day(A2)=26,86.72,0)

Assuming the due date is the same for everyone?

this would enter $0 if not late...

"Needing help at new job" wrote:

I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I really
appreciate any help.

Thanks,
Heidi

=IF(DAY(A2)=26,86.72,"whatever answer you want in the other situations")
--
David Biddulph

"Needing help at new job"
wrote in message ...
I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to
do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I
really
appreciate any help.

Thanks,
Heidi

Ok, is it possible if the "day" is left black to add the late fee?

"Sean Timmons" wrote:

Congrats on the new job!!

=IF(Day(A2)=26,86.72,0)

Assuming the due date is the same for everyone?

this would enter $0 if not late...

"Needing help at new job" wrote:

I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I really
appreciate any help.

Thanks,
Heidi

I assume that's meant to be day is left blank.

=IF(OR(A2="",Day(A2)=26),86.72,0)

"Needing help at new job" wrote:

Ok, is it possible if the "day" is left black to add the late fee?

"Sean Timmons" wrote:

Congrats on the new job!!

=IF(Day(A2)=26,86.72,0)

Assuming the due date is the same for everyone?

this would enter $0 if not late...

"Needing help at new job" wrote:

I'm trying to set up a spreadsheet to help me with my job. I track/audit
accounts for a man that does private lending. Here is what I'm trying to do:

I need a formula for "if the date in column A is 26th of each month or
later, I need column E to be a late fee of $86.72"

I really seem to have problems when it comes to the "if" fuction so I really
appreciate any help.

Thanks,
Heidi