This seems very simple but for some reason I can not get it to work for me.
What I have it a Vlookup in a sereis of cells that ultimately are added together and summed.
In the column that adds the values together I place the following if formula:
=+IF(E9="#N/A",0,D9*E9)
The idea being if there is no value for the lookup table to lookup up it places a #N/A in that cell, which in turn wreaks havoc on my addition cell and well screws the column summing all up. so I thought I might out smart excel and tell it to place a zero in the addition column when ever it sees the #n/a, this did not work , it just place #n/a in the addition cell. I don't know why it did not work. Anyone out there know where I am going wrong here?
Thanks in advance
What I have it a Vlookup in a sereis of cells that ultimately are added together and summed.
In the column that adds the values together I place the following if formula:
=+IF(E9="#N/A",0,D9*E9)
The idea being if there is no value for the lookup table to lookup up it places a #N/A in that cell, which in turn wreaks havoc on my addition cell and well screws the column summing all up. so I thought I might out smart excel and tell it to place a zero in the addition column when ever it sees the #n/a, this did not work , it just place #n/a in the addition cell. I don't know why it did not work. Anyone out there know where I am going wrong here?
Thanks in advance