Back - =IF(ISBLANK(AT5),"",AT5+5)

AT5 is a Date. What I would like for Excel to do is add 5 days to the date in AT5 but I keep getting this nasty #NAME error?

Seems to be functioning properly when I test it. How are the cells formatted? How is the date entered in AT5?

message edited by beachyhbt

Short date (ie 10/1/2016)

The formula works for me as well. Is the Destination Cell formatted the same as the source cell? Doing the best I can here... And remember, there's always more than one path to success. :)

message edited by Jennifer SUMN

Works for me too. Select the cell with your formula and then try the Evaluate Formula feature on the Formulas tab. That should allow you to Single Step through your formula to see what part is causing the #NAME error.

For example, I can force a #NAME error with this formula:

=IF(ISBLANK(AT5),"",AT+5)

When I use the Evaluate Formula feature, I can click Evaluate until I see:

=IF(FALSE,#N/A,#NAME?+5)

That tells me that the AT is causing the #NAME? error.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

I don't know what the issue is here - I tried the evaluation formula function and got this: IF(FALSE,#N/A,""+5) but unfortunately, I dont know what tis means.

One thing I do want to add that I believe may be important - there's a formula embedded in AT5, does that matter? Is it possible Excel is reading this formula and now the cell is not considered blank?

Typically "" means the cell is empty. Not 0, but empty. What is the next result if you click Evaluate one more time?

What is the formula in AT5 and what are its dependents such that the formula in AT5 evaluates to ""?

If I force AT5 to return "", I get a #VALUE! error, not #NAME!

e.g. if I put the following formula in AT5 with AT1 empty, AT5 will reslove to ""

=IF(AT1="","",0)

If I then use the Formula Evaluator on your original formula I get what you got:

IF(FALSE,#N/A,""+5)

However, one more evaluation step shows

IF(FALSE,#N/A,#VALUE!) not IF(FALSE,#N/A,#NAME!)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

So, AT5 contains a formula? You said in your first post that AT5 contains a date and then in Post 2 you gave the formatting. What exactly is in Cell AT5?

Ask Your Question

Weekly Poll