IIF function in Excel 365

[JKwan]

Wondering if "IIF" exists with Excel 365? I used it many times before and today when I start the typing "=IIF" nothing showed up??? Is there a replacement function for it? Thanks

Maybe it is my old age..... Maybe I used IIF with VBA and not as a formula???

[Aussiebear]

Microsoft support suggests that it is available in Office 365

[Paul_Hossler]

Pretty sure that you're thinking of VBA

I don't think IIF is a worksheet function since it's basically a one statement version of an If/Then/Else statement

29988


However, it is a VBA function that can simplify some If/Then/Else statements


drv = IIf(r.Value = "A", "Yes it does", "No it doesn't")

essentially replaces



If r.Value = "A" Then
drv = "Yes it does"
Else
drv = "No it doesn't"
End If

[JKwan]

thank you, gents. I think both of you are correct!