- Joined
- Aug 26, 2010
- Messages
- 1
- Reaction score
- 0
Hi,
I can't seem to get the following multiple iif statement to work
=IIf([Loss Budget]="One Offs","n/a",IIf([Loss_Budget]=0,0,([Losses]/[Loss_Budget])))
Where am I going wrong?
Thanks
I can't seem to get the following multiple iif statement to work
=IIf([Loss Budget]="One Offs","n/a",IIf([Loss_Budget]=0,0,([Losses]/[Loss_Budget])))
Where am I going wrong?
Thanks
Last edited: