Home

Formula IF not taking another formaula result as a value

%3CLINGO-SUB%20id%3D%22lingo-sub-719561%22%20slang%3D%22en-US%22%3EFormula%20IF%20not%20taking%20another%20formaula%20result%20as%20a%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719561%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20use%20the%20following%20formula%20(1)%3A%3C%2FP%3E%3CP%3E%3DIF(%5B%40%5BUnit%20Sold%5D%5D%26gt%3B%5B%40Ecom%5D%3B%5B%40Ecom%5D%3B%5B%40%5BUnit%20Sold%5D%5D)%3C%2FP%3E%3CP%3Eknowing%20that%26nbsp%3B%5B%40%5BUnit%20Sold%5D%5D%20has%20the%20following%20formula%20(2)%3A%3C%2FP%3E%3CP%3E%3DIFERROR(VLOOKUP(%24B10%3B'Unit%20Sold%20W1-W25'!%24A%241%3A%24M%244932%3B3%3BFALSE)%3B%220%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdeally%20I%20wanted%20the%20formula%201%20to%20understand%20the%20value%200%20of%20the%20formula%202%20when%20it%20is%2C%20but%20it%20doesn't%20So%20I%20have%20my%20high%20value%20showing%20instead%20of%20the%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20could%20copy%20past%26nbsp%3B%5BUnit%20Sold%5D%5D%20as%20value%2C%20but%20Im%20trying%20to%20build%20an%20automated%20file%20so%20I%20would%20like%20to%20find%20another%20solution%20and%20keep%20the%20formula%202%20in%20my%20cells%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-719561%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719605%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20IF%20not%20taking%20another%20formaula%20result%20as%20a%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719605%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366218%22%20target%3D%22_blank%22%3E%40marionatdjian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemove%20the%20quotes%20around%20the%200.%3C%2FP%3E%3CP%3EDoes%20this%20solve%20your%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719737%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20IF%20not%20taking%20another%20formaula%20result%20as%20a%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719737%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%26nbsp%3BMy%20hero%20!%20Yes%20it%20worked%20%3AD%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Hi everyone,

I would like to use the following formula (1):

=IF([@[Unit Sold]]>[@Ecom];[@Ecom];[@[Unit Sold]])

knowing that [@[Unit Sold]] has the following formula (2):

=IFERROR(VLOOKUP($B10;'Unit Sold W1-W25'!$A$1:$M$4932;3;FALSE);"0")

 

Ideally I wanted the formula 1 to understand the value 0 of the formula 2 when it is, but it doesn't So I have my high value showing instead of the 0.

 

I could copy past [Unit Sold]] as value, but Im trying to build an automated file so I would like to find another solution and keep the formula 2 in my cells

 

Thanks in advance !

2 Replies

@Deleted 

Remove the quotes around the 0.

Does this solve your problem?

 

 @Detlef Lewin  My hero ! Yes it worked :D Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies