I have a iif function that does work. But I would like it to do more. Here is my iff function
=([billAmount]-nz([ded],0))*IIf([ExpenseCategoryID]=3,0.5,IIf([ExpenseCategoryID]=7,"50.00",0.8))
This is the part not working right
([ExpenseCategoryID]=7,"50.00", I know why becasue I would like...