If you really need all of these calculations in one cell, I would suggest that you think about using a macro or splitting the formula into smaller parts instead. There's a limit to the number of nested IF statements you can have and this formula is fairly complex already. You're not able to troubleshoot the formula yourself, so if something changes you'll be stuck. It might make sense to use a couple of helper columns with simpler formulas and then hide those columns.
Kind of. If you see the red numbers A0431, A0434, A0436. If a box is checked under A0431 the price is added to to base rate (D41). the others can't interfere with it. Then the international boxes can not be check at same time as boxes above them.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!