Is there away to add to formula to when no value is there that it leave the cell blank and not give me #N/A
=SUM(SUMIF($V$14:$V$18,A12,$W$14:$W$18),
SUMIF($V$14:$V$18,C12,$W$14:$W$18))
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
- =VLOOKUP(A12,$V$14:$W$18,2,FALSE)+VLOOKUP(C12,$V$14:$W$18,2,FALSE) returns number
<o></o>
- =SUM(H12,I12)*(IF(K12=0,0,(IF(K12=0,0,1)))) returns number
<o></o>
- =SUM(H12:I12)*K12 returns number
<o></o>
- =ROUNDUP(PRODUCT(0.05,N12),0) returns number
<o></o>
- =SUM(N12:O12) returns number
<o></o>
- =M12*L12*1.05 returns number
<o></o>
- =SUM(H12,I12)*J12*1.05 returns number
- =M12/100*X12/4*(IF(K12<1,0,1)) returns number
can i get away with that formula for all my formula? no these are the formulas that work for my sheet.