View Full Version : [SOLVED:] IIF function in Excel 365
JKwan
07-26-2022, 08:16 AM
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
07-26-2022, 01:26 PM
Microsoft support suggests that it is available in Office 365
Paul_Hossler
07-26-2022, 02:10 PM
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
07-26-2022, 03:04 PM
thank you, gents. I think both of you are correct!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.