Complicated Formula

G

George

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.
 
J

JLatham

I'm focusing on the part of your explanation that says:
"If cell D3 changes to 3A, 6A or SS, cell Q3 remains blank. ..."
I am also assuming that those entries, plus 3G, 4G, 5G, 6G, 6L, 3T, 4T, 5T
and 6T are the only other possible values that can appear in D3.

If I'm wrong about those assumptions, let us know.

But this should work in those circumstances as a formula for Q3:
=IF(OR(D3="3A",D3="6A",D3="SS"),"",([your formula here])*Q2)

Where you replace the [your formula here] within those parenthesis with the
formula you say you have for getting the sum of the other cells needed to be
multiplied by the contents of Q2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top