IF Function Help

**jay1983** · 10-26-2009, 09:21 AM

=IF(OR(DAY(B4)<=DAY($O$1),(K4=0)),"DUE","")

O1 = the current date.

how can i make the following function have 2 statments eg,

if the day b4 is less than or equal to O1 then return "due", however if k4 = 0 the it will be blank. they need to be two seperate functions.

do i need to if statements?

**NBVC** · 10-26-2009, 09:34 AM

You mean?

=IF(K4=0,"",IF(DAY(B4)<=DAY($O$1),"DUE")

**darkyam** · 10-26-2009, 10:32 AM

I could be misunderstanding something, but I don't think using the Day function will work. It will return an incorrect answer when the current day is the 31st and the due date is the first of the next month.

**jay1983** · 10-26-2009, 11:08 AM

You mean?

=IF(K4=0,"",IF(DAY(B4)<=DAY($O$1),"DUE")

Great thanks works,

But when the due date is not due it responds with a result FALSE, how can i make it blank when the due date is not due.

**NBVC** · 10-26-2009, 11:20 AM

Add the condition:

=IF(K4=0,"",IF(DAY(B4)<=DAY($O$1),"DUE","")

**jay1983** · 10-26-2009, 12:57 PM

Great Works,

Thanks for your help...

You may be able to help with the following,

I have a field that you enter an amount once someone has paid, i also have another field where once that amount has been paid it is deducted from the total owed.

example if £550 is owed and £300 is paid then the balance remaining is £250.

what i need is in the field where you enter how much is paid, i need this field to let me enter an amount in there and then once it enters it calculates and saves the amount but leaves the field blank again so i can enter another amount in there example the remaining £250 can be entered leaving the total to £0.

Can you help, i know it sounds a bit funny but thats the best way i could explain.

Thanks in Advance.

**jay1983** · 10-26-2009, 01:04 PM

Originally Posted by darkyam

I could be misunderstanding something, but I don't think using the Day function will work. It will return an incorrect answer when the current day is the 31st and the due date is the first of the next month.

Hi your right it will not work, do you have any solutions to make this work.

say for example the payment is due every 10th of the month, i need a promt to let me know the payment is due and it needs to stay due untill paid.

**darkyam** · 10-26-2009, 01:14 PM

Just take the Day part off: =IF(K4=0,"",IF(B4<=$O$1,"DUE","").
As for your other question, I'm afraid I can't help with that. It would require VBA and I'm still no good at that. I'm sure NBVC or someone else could whip that up for you easily, though.

**jay1983** · 10-26-2009, 03:06 PM

In one field is the day eg 20 or 27 etc.

and the day today is 20-10-2009.

I would need the field to promt due when it is the 20th.

and if the 20 occurs over several months i still need it to promt untill paid.