Formula IF not taking another formaula result as a value

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