Hi
I use the fuction LOOKUP(1E+100;C6:C25)-C6, to return a value in G10, which
work if there is value in C6:C25, but if there is not any value in C6:C25, it
return the "#N/A", how can I make cell G10 to not show "#N/A", if there is
not any numbers in C6:C25.
Another question, I use the LOOKUP(1E10;C6:C25)-C6, but it change to
LOOKUP(1E+100;C6:C25)-C6 automatically, why, what the "1E10" mean.
Thank in advance for help