|re: Your subject line: "Why is the answer an invisble 0"|
What does this have to do with the rest of your question?
re: "This formula is in cell AV"
AV is a column, not a cell.
re: This portion of your formula: "IF(N662=100,(Q663,Y663,AG663)"
What is this supposed to mean? (Q663,Y663,AG663)
There's no function or operator associated with those cells. Excel will not know what to do with those cells.
It sounds like this is your criteria:
1 - If N662 in blank, then return a blank cell
2 - If N662 contains 100, then SUM(Q663+Y663+AG663)
2a - If SUM(Q663+Y663+AG663) <=99.99, then return that SUM
2b - If SUM(Q663+Y663+AG663) is not <=99.99, then return 100
There is a one criteria missing:
What happens if N662 is NOT blank and does NOT contain 100? e.g. What do you want returned if N662 contains 50 or 87 or Bob?
Other than that final question, this formula appears to do what you want. However, if N662 contains e.g. 50 or 87 or Bob, the formula will return FALSE because we have not told it what to do if N662 is anything other than Blank or 100.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.