Gday Ive just started using excel and this is my first time on a forum so i hope im on the right track. In column D i input either S(short) or L(long) when i input S i want column K to subtract column H from column G. And when I input L i want column K to subtract column G from column H. If anyone could help me with this it would be much appreciated.