Correcting my IF with AND function formula

[Teresa Skiba]

Please could you correct my formula. The description is:
If cell A1 is not blank and cell C is blank, calculate today's date minus the date in A1 (to arrive at aged debt).

I came up with a formula:

=IF(AND(A1="","",C1=ISBLANK),TODAY()-A1)

- but get a 'value' error message.

I've spent hours trying to figure this out so would be really grateful for any help!

Many thanks.

Teresa

[FDibbins]

=if(and(a1="",c1=isblank),"",today()-a1)

variation...
=IF(A1+C1=0,"",TODAY()-A1)

in both, i may have the "" in the wrong place, adjust as needed

the 1st formula should read,,,

=if(and(this=something,that=something),return-this,else-return-that)

[Teresa Skiba]

Thanks very much for your reply. I tried your formula but it still came up with an error message so I attach the spreadsheetI used.

Thanks again in advance.

Teresa

[martindwilson]

=if(and(a1<>"",c1=""),today()-a1),"")
you cant have
c1=isblank
you could use
isblank(c1)

=if(and(a1<>"",isblank(c1)),today()-a1),"")

[FDibbins]

@ Martin. i think the OP wanted A1="" not A1<>"" ?

[martindwilson]

@ fd

If cell A1 is not blank and cell C is blank

c1=isblank will always give an error its just not correct
Teresa Skiba please read all solutions
=IF(AND(A1<>"",C1=""),TODAY()-A1,"") gives 164

[Teresa Skiba]

Thanks SO MUCH! That was really bugging me. Now I can get on with my life..

Teresa

[FDibbins]

lol ok Martin, i was looking at the formula, not the text

@Teresa...
we are happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)