Does Excel have an IIF equivalent

[rusty58]

Hi

Does excel have an equivalent function to IIF in Access?

The IF statement appears to about it.

Thanks

 

[ETID]

The usage for the if is similar to iif


=if(A1>10,"Yeah it's > 10","Try harder")

=if(A1>10,"Yeah it's > 10",C1)

=if(A1>10,b1,c1)

=if(and(A1>10,b1>10),"Yeah both are > 10","Try harder")

=if(or(A1>10,b1>10),"Yeah at least 1 of the 2 are > 10","Try harder")

 

[TonyJollans]

Hi Rusty,

Not quite sure what your question means. The IIf (Immediate If) is essentially a function which provides 'if functionality' inline. In Access you can use it in queries or in VBA. In Excel (or any other app) you can use it in VBA. In an Excel worksheet, the IF function does exactly the same. What more do you want?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[SkipVought]

AND...

you can use the IIF function in Excel Queries (Data/Get External Data...)

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}