| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stuck With Excel Problem
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stuck With Excel Problem
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stuck With Excel Problem
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? "Jacob Skaria" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stuck With Excel Problem
I would think it easier to either put the trigger in another column. What
will cause C to be mutliplied? "Jeremy" wrote: 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? "Jacob Skaria" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stuck With Excel Problem
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" wrote: I would think it easier to either put the trigger in another column. What will cause C to be mutliplied? "Jeremy" wrote: 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? "Jacob Skaria" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stuck With Excel Problem
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... "Jeremy" wrote: 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" wrote: I would think it easier to either put the trigger in another column. What will cause C to be mutliplied? "Jeremy" wrote: 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? "Jacob Skaria" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoCalc in Excel is stuck! | Excel Discussion (Misc queries) | |||
| Excel with game is stuck in a loop | Excel Discussion (Misc queries) | |||
| Stuck Button effect in Excel | Excel Discussion (Misc queries) | |||
| Excel Concatenate - Please help, really stuck | Excel Discussion (Misc queries) | |||
| Help - now really stuck! File transfer problem | Excel Discussion (Misc queries) | |||
Linear Mode
