IFS returning #Value

%3CLINGO-SUB%20id%3D%22lingo-sub-1901849%22%20slang%3D%22en-US%22%3EIFS%20returning%20%23Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1901849%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20create%20a%20pricing%20sheet%20within%20Excel.%26nbsp%3B%20I%20have%20created%20multiple%20drop%20down%20lists%20and%20am%20attempting%20to%20attach%20values%20to%20each%20drop%20down%20expression.%26nbsp%3B%20I%20have%20done%20it%20successfully%20once%20but%20on%20the%20second%20one%20it%20is%20returning%20%23value%20as%20if%20the%20answer%20is%20something%20other%20than%20true%20or%20false.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1901849%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1901968%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20returning%20%23Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1901968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F873642%22%20target%3D%22_blank%22%3E%40Neal_Arnett%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20attach%20a%20sample%20workbook%20or%20screenshot%20of%20the%20error%3F%3C%2FP%3E%3CP%3EIt%20seems%20like%20you%20would%20have%20to%20add%20an%20IFERROR%20expression%20to%20the%20beginning%20for%20the%20formula%20to%20handle%20any%20value%20that%20doesn't%20fit%20any%20criteria%20that%20%22is%20something%20other%20than%20TRUE%20or%20FALSE%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1902236%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20returning%20%23Value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1902236%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3BI%20figured%20it%20out.%26nbsp%3B%20I%20wasn't%20referencing%20the%20base%20cell%20on%20each%20argument.%26nbsp%3B%20There%20has%20to%20be%20an%20easier%20way%20to%20do%20this.%26nbsp%3B%20But%20I'm%20getting%20it%20done.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am attempting to create a pricing sheet within Excel.  I have created multiple drop down lists and am attempting to attach values to each drop down expression.  I have done it successfully once but on the second one it is returning #value as if the answer is something other than true or false.  

 

2 Replies

@Neal_Arnett 

Can you attach a sample workbook or screenshot of the error?

It seems like you would have to add an IFERROR expression to the beginning for the formula to handle any value that doesn't fit any criteria that "is something other than TRUE or FALSE".

@adversi I figured it out.  I wasn't referencing the base cell on each argument.  There has to be an easier way to do this.  But I'm getting it done.