I have a table in Excel and some equations in columns for all the rows.
I have an equation like this:
= IF ([@C1]= 0,[@C2]MIN[@C1], [@C2]))
and then like this:
= IF ([C1]= 0,[C2]MIN[C1], [C2]))
The objective is to check the column.
C1 What if it is not
0use minimum between
If I use the first option with
@, it works well, while the second one always comes back.
0, no matter what is in
What is the difference between the equations?