[AccessD] OT - Excel - IIF in cell

Bryan Carbonnell carbonnb at gmail.com
Wed Apr 25 10:01:11 CDT 2007


On 4/25/07, JWColby <jwcolby at colbyconsulting.com> wrote:
> As always, immediately after I pressed Send I discovered the answer.
>
> =if((E3="x"),0,C3)
>
> Now why doesn't IIF work?

'Cause IIF is not a valid function in Excel Formulas.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"



More information about the AccessD mailing list