COMBINING FORULAS

[Jewells0905]

Hi,
I am having so much trouble learning how to properly combine multiple functions/arguments into one functioning formula. There are three types of problems in Columns A:D, NULL values, #N/A values, and blank cells. I need all of these to be turned into #N/A values, and have been directed to do so using the IFS function. Here is the formula I am trying, but I keep getting a parse error with this. =IFS(ISNA(A2), OR(ISBLANK(A2), (ISERR(A2), "#N/A"))). I have also tried =IFS(OR(ISNA(A2), (ISBLANK(A2), (ISERR(A2), "#N/A"))), with the same error. And =IFS(OR(ISNA(A2), ISBLANK(A2), ISERR(A2), "#N/A")), which has given me the #N/A error, stating not enough arguments. I am not able to upload a mini sheet, but below is a shot of part of the sheet I am working with. Any help is appreciated.

Food Name	Scientific Name	Group	Subgroup		Food Name	Scientific Name	Group	Subgroup
Angelica	Angelica keiskei	Herbs and Spices	Herbs		#N/A
Savoy cabbage	Brassica oleracea var. sabauda	Vegetables	Cabbages
Silver linden	Tilia argentea	Herbs and Spices	Herbs
Kiwi	#N/A	Fruits	Tropical fruits
Allium (Onion)	Allium	Vegetables	Onion-family vegetables
Garden onion	Allium cepa	#N/A
Leek	Allium porrum	Vegetables	Onion-family vegetables
Garlic	Allium sativum	Herbs and Spices	Herbs
Chives	Allium schoenoprasum	Herbs and Spices	Herbs

 

[SanjayGMusafir]

Check this and revert -

=IFS(OR(ISNA(A2),ISBLANK(A2),ISERR(A2)),"#N/A",True,A2)

 

[shift-del]

Hi

The formula spits out #N/A text and not #NA error.

Mappe8
	A	B	C	D	E	F	G	H	I
1	Food Name	Scientific Name	Group	Subgroup		Food Name	Scientific Name	Group	Subgroup
2	Angelica	Angelica keiskei	Herbs and Spices	Herbs		Angelica	Angelica keiskei	Herbs and Spices	Herbs
3	Savoy cabbage	Brassica oleracea var. sabauda	Vegetables	Cabbages		Savoy cabbage	Brassica oleracea var. sabauda	Vegetables	Cabbages
4	Silver linden	Tilia argentea	Herbs and Spices	Herbs		Silver linden	Tilia argentea	Herbs and Spices	Herbs
5	Kiwi	#N/A	Fruits	Tropical fruits		Kiwi	#N/A	Fruits	Tropical fruits
6	Allium (Onion)	Allium	Vegetables	Onion-family vegetables		Allium (Onion)	Allium	Vegetables	Onion-family vegetables
7	Garden onion	Allium cepa	#N/A			Garden onion	Allium cepa	#N/A	#N/A
8	Leek	Allium porrum	Vegetables	Onion-family vegetables		Leek	Allium porrum	Vegetables	Onion-family vegetables
9	Garlic	Allium sativum	Herbs and Spices	Herbs		Garlic	Allium sativum	Herbs and Spices	Herbs
10	Chives	Allium schoenoprasum	Herbs and Spices	Herbs		Chives	Allium schoenoprasum	Herbs and Spices	Herbs
Tabelle1

Cell Formulas
Range	Formula
F2:I10	F2	=IF(ISTEXT(A2),A2,"#N/A")

 

[Jewells0905]

Check this and revert -

=IFS(OR(ISNA(A2),ISBLANK(A2),ISERR(A2)),"#N/A",True,A2)

 

[Jewells0905]

This one is not throwing an error, but is giving me the same results as this formula that I had tried as well, it is just populating all the food names from Column A regardless whether it should be a #N/A.

=IF(OR(A2="NULL", ISNA(A2), ISBLANK(A2)), "#N/A", A2)

 

[SanjayGMusafir]

Have you tried the formula I gave you in #2

=IFS(OR(ISNA(A2),ISBLANK(A2),ISERR(A2)),"#N/A",True,A2)