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*B 1)

If this post helps click Yes
---------------
Jacob Skaria


"Jeremy" wrote:

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