I cannot get this formula to work:
IF(G9="H""K""L""M""N""O""P",H8-E9,H8)))
If G9 has any of those letters I want it to perform the h8-h9 formula. I have tried a bunch of stuff and I am even using the "excel 2002 formulas" book by Walkenbach. I don't get an error, it will only recognize if I have 1 letter in the arguement. I tried using brackets around the group of letters as well.
This message was edited by Nsdqdu on 2002-05-04 17:17
This message was edited by Nsdqdu on 2002-05-04 17:18
IF(G9="H""K""L""M""N""O""P",H8-E9,H8)))
If G9 has any of those letters I want it to perform the h8-h9 formula. I have tried a bunch of stuff and I am even using the "excel 2002 formulas" book by Walkenbach. I don't get an error, it will only recognize if I have 1 letter in the arguement. I tried using brackets around the group of letters as well.
This message was edited by Nsdqdu on 2002-05-04 17:17
This message was edited by Nsdqdu on 2002-05-04 17:18