na()

Hi all, I am trying to create a workbook that plots a line chart of two data sets. the problem i am running into is that some of the time-stamps from one set will not match up with the others, and thus need to be ignored. i managed to do this with if statements easily, and currently, any non...

Hello all, I am trying to use the IFERROR formula below =IFERROR(C15+C16+C17)/C21,NA()) Excel is using the parentheses, for the order of operations, to close the IFERROR formula. Is there a way to maintain order of operations, without parentheses? Thanks,

I have 3 tables, each has 39 rows and 5 columns. They are located in the same columns (I-M), above each other. (with a few rows in-between, and titles) Each cell in the 3 tables contains either a number from 6-100, to two decimal places or an =NA(). I'm trying to make a new table at the...

I have a table of numbers with totals and am currently trying to graph them with a trendline. The table is for totals at the end of each month plus the last 2 months of the prior year. My trendline picks up the zero values that are currently being summed for the months that have yet to be...