Iif()

[vbjohn]

Can you tell me what is wrong with this code...



=IIF([DFC] => 11000 AND [AGE] => 50,"12000", (IIF [DFC] => 11000 AND [AGE] < 50, "11000", [DFC]))

I keep on looking it over and can not see it anywhere.

It tells me.. "You May Have Entered In A Comma Without a preceding value or indentifier".

 

[The_Doc_Man]

=IIF([DFC] => 11000 AND [AGE] => 50,"12000", (IIF [DFC] => 11000 AND [AGE] < 50, "11000", [DFC]))


Try

=IIF(([DFC] => 11000 ) AND ( [AGE] => 50)) ,"12000", IIF (([DFC] => 11000) AND ([AGE] < 50)), "11000", [DFC]))

 

[BLeslie88]

Well...

=IIF([DFC] => 11000 AND [AGE] => 50,"12000", (IIF [DFC] => 11000 AND [AGE] < 50, "11000", [DFC]))

'(' in wrong place.....
=IIF([DFC] => 11000 AND [AGE] => 50,"12000", IIF ([DFC] => 11000 AND [AGE] < 50, "11000", [DFC]))

Regards,