using sum and iif

F

Floyd Forbes

How do I write an expression using sum iif ?
I'm trying to sum Ten textboxes in one textbox base on IIF a value
is greater or less than in one of the Ten textboxes.

Floyd
 
C

Col

Try

Sum(IIF(textbox1>somevalue,textbox1,0)+IIF(textbox2>somevalue,textbox2,0)+IIF(textboxn>somevalue,textboxn,0))

Col
 
Top