IIF function

[SharmaAntriksh]

https://uploadfiles.io/glxo4

i have this file at the following link in which i want to apply iif function in a way that if S1 = Operation(S1) then give me value from total otherwise remain blank

IIF S2 = S2(operation) then give me value from the same row of the total column otherwise remain blank

 

[Joe4]

IIF is not a function in Excel. Both Excel and Excel VBA use IF.
See: https://exceljet.net/excel-functions/excel-if-function

 

[Fluff]

@Joe4
I think this should be in the Access forum.
I reported a duplicate posting yesterday & didn't realise that 1 was in the Access forum & 1 in the xl forum.

 

[Joe4]

I think this should be in the Access forum.
I reported a duplicate posting yesterday & didn't realise that 1 was in the Access forum & 1 in the xl forum.

OK, I have moved it to the Access forum.

SharmaAntriksh,
I do not have the ability to download that file.
Can you explain your question in more detail? Is "Operation" some User Defined Function that you have built?
Here is information on the IIF function in Access: https://www.techonthenet.com/access/functions/advanced/iif.php

 

[mrhstn]

FWIW

IIf is an excel VBA function...

IIf(Expression, TruePart, FalsePart)

Sub test()
Dim testValue As Boolean
testValue = True
MsgBox IIf(testValue, "True", "False")
End Sub

 

[Joe4]

IIf is an excel VBA function...

IIf(Expression, TruePart, FalsePart)

Interesting...

I have not seen it used that way before, but that is good to know.