Excel Magic Trick 961: Calculate Total Savings: Old Price, New Price & Quantity IFNA 2013 Function

[@excelisfun]

I am glad that you got it figured out!

[@excelisfun]

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.

[@Sue35983]

I figured it out , no problem
sorry and thank you for all these
I love them
sue

[@excelisfun]

It will not work. You will get a #NAME? error because it will not understand the text IFNA.

[@excelisfun]

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.

[@B1TNY08]

Great IFNA function but what happens if use use this in 2013 and then someone uses the workbook in 2010?

[@excelisfun]

Try Chrome Browser.

[@paragbhuyan7386]

what if the volume or quantity changes ? how do you then calculate the total savings?

[@Sue35983]

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

[@knrd87]

Any advantage in using ifna instead of iferror in such situation?

[@BYUIGUY]

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?

[@excelisfun]

I do not understand your question. Sorry.

[@yasirkhan76]

files link are not working plz updated