Sum of Iif statement

[LadyDiss]

Is it possible to sum Iif statements. I have been working on a project that has several Iif statements, i.e. for bonuses, if # is greater than 0, 10, if less, 0 . . . now I need to sum the Iifs, and so far not having any luck. Any suggestions? Thanks!

 

[Fornatian]

It is possible, but you may get lost in the formulae if your statements are too complex.

Post your rules of engagement and let the forum help you.

 

[LadyDiss]

I don't know how to really explain this, but here goes:
Example:

Name Bonus
Amount 4
2nd Amount -2

The bonus amount is calculated by =IIf([Amount]>0,"10","0") . . . and the 2nd bonus amount =IIf([2nd Amount]>0,"10","0")

There are about 20 of these all together . . . now I need to calculate the bonus amount column for each person. Does this make sense?

 

[Rich]

[Text1]+[Text2] etc?

 

[LadyDiss]

Tried that . . . if the numbers are 0 0 10 10 . . . that is what I get . . . 001010

 

[Fornatian]

Using the & operator concatanates the arguments, try your formula again using the + operator.

 

[LadyDiss]

I used this:

=[Text15]+[Text16]

and it returned 010 or 1010 . . . am I missed the boat here?

 

[Fornatian]

Are your text boxes formatted as numbers?

 

[Rich]

You are enclosing your numbers with quotes, which turns them into text. It should be
=IIf([Amount]>0,10,0)

 

[LadyDiss]

Thank you so much!!!!!! This works! Hard to believe a " can make so much difference!

 

[Fornatian]

Well spotted - eagles eyes.