IIF Statements

[DanSc0tt]

This should be really simple, but just not working!!

I have three text boxes 1,2 & 3 - I want to calculate a value in three based on 1 & 2, but return "0" if either of 1 or 2 are "0". So i tried

IIF([1] or [2] = 0,0,([2]-[1])/[1])

it doesn't work

am i doing something silly???

Dan

 

[Nancy2]

Here you go - this one also checks for null values:

=IIf(nz([1])<>0,IIf(nz([2])<>0,([2]-[1])/[1],0),0)

 

[lameid]

IIF(([1] = 0 or [2] = 0),0,([2]-[1])/[1])

 

[brau]

Try this

IIF([1]= 0,0,IIF([2]=0,0,([2]-[1])/[1])))

Bob