Excel 2007
I am looking for a formula to do the following;
When the contence in cell D3 is changed, it adds a number to one of the
following cells, (E3 to P3), if the number shows up in cells G3, H3, I3, J3,
K3, M3, N3, O3, OR P3, then cell Q3 = the sum of one of the above, (whichever
one has the number in it), x Q2
If the number shows up in E3, F3 OR L3, then Q3 must remain blank.
I already have the forumla to add the numbers in the cells, I am only
looking for the formula to enter in cell Q3
If cell D3 changes to 3A, 6A or SS, cell Q3 remains blank. If cell D3
changes to any one of the following; 3G, 4G, 5G, 6G, 6L, 3T, 4T, 5T or 6T,
cell Q3 = the sum of whatever cell is showing the number x Q2
I hope I have explained this correctly, it's the same formula, just
explained twice.