Fill cell from an IF ELSE type scenario

[Mizztah]

Hi

I'm happy using Excel for straightforward number crunching but have never had to look beyond this. I now need to progress a tad further and have been looking at ways to do the following:

Column A contains a list of names
Column D has a combo box with a Yes/No option(is the person competent)
Column E contains a date(if competent date last test otherwise if not competent the cell is empty).

Column F requires populating with either:

Not Required -----if the person is not competent
Date which is 730 days from the last competency test(Column E)

I looked around at a few sites and cobbled toger this:

=IF(E5="","Due Now",IF(D5="No","Not Required",(E5+730) ))


which I thought worked but doesn't quite. If a date is entered in Column E it will display correctly if selecting "Yes" or "No" in Column D but if I remove the date the Column E cell is defaulting to "Due Now" which would be incorrect as a person without a competency will have no date and the entry for the cell should be "Not Required".

Can someone put me out of my misery !

Thanks
MizztaH

[Richard Buttrey]

Hi

So what is the condition that should generate a "Due Now" result?
At the moment your formula is working correctly. i.e. if you have nothing in column E it correctly returns "Due Now" from the first IF test.

Rgds

[Mizztah]

Thanks for the swift response.

If colum D has a value of "Yes" and Column E is blank(no competency test date) then column F should display a "Due Now".
I thought it worked but if Column D has a value of "No" I should get a "Not Required" but instead I'm getting "Due Now".

Thanks
MizztaH

[Richard Buttrey]

Hi

In that case try:

Please Login or Register  to view this content.

HTH