Nested if formula

[ADAMC]

Hi all,

I wonder if someone can help me with a formula please I cannot get my head around it so its best to write it in words: It is so difficult to explain my actual spreadsheet but here goes:

The formula would be filled down the column starting in O2

If the date in E2 IS LESS THAN OR EQUAL TO TODAYS DATE THEN TODAYS DATE + N2, IF THE DATE IN E2 IS GREATER THAN TODAYS DATE THEN E2 + N2, IF N2 IS BLANK THEN "" (BLANK)

Thank you

 

[AlanY]

this is exactly what you're asked for but made no sense as both conditions for E2 ended up with today() + N2

=if(N2="","",if(E2<=today(),today()+N2,today()+N2))

 

[ADAMC]

Thanks for replying.

So I tried something similar and I get a circular reference error and I cant figure out why it looks like its the today() part that causes the error?

the date in E2 can either be a date in the past or a date ahead so the second part I think should be like this:

=if(N2="","",if(E2<=today(),today()+N2,E2()+N2)) however this also gives a circular error.

 

[Joe4]

So I tried something similar and I get a circular reference error and I cant figure out why it looks like its the today() part that causes the error?

So, you are putting that formula Alan came up with in cell O2, right?
What exactly is in cells E2 and N2?
Are either formulas? If so, please post the formula(s).

I think the formula should probably look like this:

[COLOR=#333333]=if(N2="","",if(E2<=today(),today()+N2,[/COLOR][COLOR=#ff0000]E2[/COLOR][COLOR=#333333]+N2))[/COLOR]

 

[AlanY]

just saw Joe's post, he is correct

 

[ADAMC]

Joe, apologies I was actually putting the formula in the wrong place, it was E2+ N2 as you said.

Thank you AlanY exactly what I needed.