Is it possible to update a column of IF statements to the "number" where the IF statement returns a positive value, otherwise leave it as an IF statement (probably via VBA code)?
This is an abridged version of the IF statement “=IF(C33=$K$9,$K$10,0)”.
Thanks,
SKK