#### typewriterguy

##### New Member

- Joined
- Oct 29, 2008

- Messages
- 24

When either AL6 or AM6 have a value that is not zero or null, I want the formula to sum AJ6, AL6, AM6.

When both AL6 and AM6 have a null/zero value, I want the formula to return a value of

**"-".**

**Desired results**

AJ6: Original value = 500

AL6: Change1 value = <NULL>

AM6: Change2 value = 50

AP6: Formula <FORMULA>desired result = 550

AJ6: Original value = 500

AL6: Change1 value = <NULL>

AM6: Change2 value = <NULL>

AP6: Formula <FORMULA>desired result= "-"

I tried =IF((AL6,AN6),SUM(AJ6,AL6,AN6),"-"), but it returned a #VALUE message.