If you use IFNA, any non-NA error will cause the formula to show the error, and sometimes that is what you want; meaning, you want to know when there is a non-NA error. IFERROR is great when you do not want to see any errors. For example, for some calculations you may want to not show NA, but see Divide By Zero error.
I do not have one for the specific situation. Try post your question to this alternative site (not affiliated with excelisfun at RUclips): mrexcel [dot] com/forum+ This site is great for getting specific solutions.
Hi I don't understand why I can't copy the formula to the next column , I get wrong figure & F5 is typed in first column (saving-increase) column I mean thank you sue
I have to run a mastersheet with 4 large excel data workbooks feeding into the master. Do you have any videos that can show linking external workbooks together?
I am glad that you got it figured out!
If you use IFNA, any non-NA error will cause the formula to show the error, and sometimes that is what you want; meaning, you want to know when there is a non-NA error. IFERROR is great when you do not want to see any errors. For example, for some calculations you may want to not show NA, but see Divide By Zero error.
I figured it out , no problem
sorry and thank you for all these
I love them
sue
It will not work. You will get a #NAME? error because it will not understand the text IFNA.
I do not have one for the specific situation. Try post your question to this alternative site (not affiliated with excelisfun at RUclips):
mrexcel [dot] com/forum+
This site is great for getting specific solutions.
Great IFNA function but what happens if use use this in 2013 and then someone uses the workbook in 2010?
Try Chrome Browser.
what if the volume or quantity changes ? how do you then calculate the total savings?
Hi
I don't understand why I can't copy the formula to the next column , I get wrong figure & F5 is typed in first column (saving-increase) column I mean
thank you
sue
Any advantage in using ifna instead of iferror in such situation?
I have to run a mastersheet with 4 large excel data workbooks feeding into the master. Do you have any videos that can show linking external workbooks together?
I do not understand your question. Sorry.
files link are not working plz updated