Stuck With Excel Problem

[Jeremy]

I have a formual that reads like below
A1*B1=D1
A B C D
1 5 2 10
2
3

What if I have a varable where sometimes it would be A1*B1*C1? B1 is always
a fixed number and C1 will always be a fixed number leaving A the number that
changes. Could I put a character after the number is typed in A1 to trigger
it to multiply B & C or could I color the cell to do this?

Thank you

 

[Jacob Skaria]

If you would like to add a character like + which will take on ABC; try the
below

Col A Col B Col C Col D
5+ 2 2 =formula

=IF(RIGHT(A1,1)="+",SUBSTITUTE(A1,"+",)*B1*C1,A1*B1)

If this post helps click Yes

 

[Jeremy]

Question, now if you try and add A1 with the 5+ in another cell you will get
a 0 or #Value. How do we fix this?

 

[Sean Timmons]

I would think it easier to either put the trigger in another column. What
will cause C to be mutliplied?

 

[Jeremy]

I agree but the problem is there is alot of data and it would require an
additional 50 columns to be added. Can you trigger off of a color function?

 

[Sean Timmons]

In 2003, you wouldn't be able to do without a macro.

If you know which rows require column C be added, then perhaps there is
simple formula logic you can use? Is it where A is a certain value? Then,
you can use If or LOOKUP to get there...

 

[RagDyeR]

From your original formula, it looks like you're *only* looking for a
Logical return of TRUE or FALSE, *not* the results of a calculation.

Is that so?

What is it that determines when "A" is added to the formula mix?

Is it simply when "A" is populated, or is there another factor involved?

You'll need to give us more info!