Multiple criteria using IIF

[YasserKhalil]

Hello everyone
I tried to use IIF to include four criteria in one line

Please Login or Register  to view this content.

I got an error at this line (Argument not optional) .. How to adapt this using IIF?
Please don't post solutions using If or Select Case ...
My issue with IIF statement ..
Is it possible to adapt IIF for mutliple criteria ..?

[pjwhitfield]

Its not to do with the IIF, the error is that you dont have an alternative ending if its not Sheet 4, add another comma and then what you want to return if its none of the expected sheets.

[YasserKhalil]

Thank you very much
You are great .. That's solved the problem
But what if I don't need to assign value for alternative ending..In my code the criteria will be just four no more

[pjwhitfield]

if you're saying that its not possible to have anything other than those 4 sheet names then you can put anything there it will never hit that point however it may be wise to put something that stands out "#ERROR" or something just to highlight if something unexpected happened.

On that logic though you dont need the 4th IIF, youre basically saying at that stage it has to be Sheet4 and therefore you can remove that IIF statement and add in the ,5 as the FALSE on the sheet3 question

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much for great and awesome help
Best regards