Hello,
I'm trying to do a if(sum function and I keep getting the message that more arguments have been specified for this function than are allowed in the current file format. The function that I am using is a standard one that I have been using for budgets that I have been building for a while now and I have never had this message returned to me. If anyone could take a look at this formula and let me know if you see any errors it would be greatly appreciated.
=IF(SUM(J54,J164,J274,J384,J494,J604,J714,J824,J934,J1044,J1154,J1264,J1374,J1484,J1594,J1704,J1814,J1924,J2034,J2144,J2254,J2364,J2474,J2584,J2694,J2804,,J2914,J3024,J3134,J3244,J3354,J3464)=0,0,IF(SUM(J54,J164,J274,J384,J494,J604,J714,J824,J934,J1044,J1154,J1264,J1374,J1484,J1594,J1704,J1814,J1924,J2034,J2144,J2254,J2364,J2474,J2584,J2694,J2804,J2914,J3024,,J3134,J3244,J3354,J3464)=0.5,0,IF(SUM(J54,J164,J274,J384,J494,J604,J714,J824,J934,J1044,J1154,J1264,J1374,J1484,J1594,J1704,J1814,J1924,J2034,J2144,J2254,J2364,J2474,J2584,J2694,J2804,J2914,J3024,J3134,J3244,J3354,J3464)<0.5,ROUNDUP(SUM(J54,J164,J274,J384,J494,J604,J714,J824,J934,J1044,J1154,J1264,J1374,J1484,J1594,J1704,J1814,J1924,J2034,J2144,J2254,J2364,J2474,J2584,J2694,J2804,J2914,J3024,J3134,J3244,J3354,J3464),0)-0.5,ROUNDUP(SUM(J54,J164,J274,J384,J494,J604,J714,J824,J934,J1044,J1154,J1264,J1374,J1484,J1594,J1704,J1814,J1924,J2034,J2144,J2254,J2364,J2474,J2584,J2694,J2804,J2914,J3024,J3134,J3244,J3354,J3464),0)) SUM(J54,J164,J274,J384,J494,J604,J714,J824,J934,J1044,J1154,J1264,J1374,J1484,J1594,J1704,J1814,J1924,J2034,J2144,J2254,J2364,J2474,J2584,J2694,J2804,J2914,J3024,,J3134,J3244,J3354,J3464)))
-Cuda
Bookmarks