gday ive just started using excel and in column D i input either L (long) or S (short). When I input L i want column K to subtract column G from column H and when I input S I want column K to subtract column H from column G. if anyone could help me with this formula it would be much appreciated.