What abt to a cell only? I seem to get error with the true or false value
enclose in bracket!
"Bob Phillips" wrote in message
...
It means that the cell formula is referring to itself. Look up 'Formulas
that refer back to their own cells' in the Answer Wizard in help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crapit" wrote in message
...
What is a circular reference?
"Bob Phillips" wrote in message
...
Range("E2:E6").Formula = "=IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),""Not
Available"",IF(E2-TODAY()<0,""Expendite"",E2-TODAY()) )"

but you will get a circular reference, as you have been told before.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"crapit" wrote in message
...
How do i insert the following formula from range e2 to j26?
IF(OR(ISERROR(E2-TODAY()),ISBLANK(E2)),"Not
Available",IF(E2-TODAY()<0,"Expendite",E2-TODAY()) )