coklu iif formulu

1 2
24/04/2012, 17:46

accessman

şunu deneyin
Kod:
Euro: IIf([salarytype]="MONTHLY" And [currency]="EURO";[salary]*[Kur];IIf([salarytype]="MONTHLY" And [currency]="USD";[salary]*[Kur];IIf([salarytype]="MONTHLY" And [currency]="RUBLE";[salary]/[Kur];IIf([salarytype]="HOURS" And [currency]="EURO";[salary]*[Kur];IIf([salarytype]="HOURS" And [currency]="RUBLE";[salary]/[Kur];0)))))
24/04/2012, 17:54

orhantanriverdi

Sayın hocam teşekkür ederim. Konu çözülmüştür SAYGILAR
1 2