iif inside an iif statement??? 1

[kingz2000]

Hi Guys,
Is it possible to have an iif inside an iif as far as formulas are concerned??
For example I have a formula :

=iif([service_anz_stops]=0;"";round((1-[service_op]/[service_anz_stops])*100;2) & '%')

but sometimes the outcome is negative, in which case it should just give 0.How do I do that?
Thanks in advance

 

[lupins46]

=iif([service_anz_stops]=0,"",
iif([service_op]>=[service_anz_stops], 0,round((1-[service_op]/[service_anz_stops])*100,2) & '%'))

 

[kingz2000]

thanx lupins46!!