| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data of two cells into one and change formula accordinaly
I was given the following formula:
=C$5 & "@" & C$6 & " A, B, C" However, I want it to be changed to the following formula: =C$5 & "@" & C$6 & " A, B, C, D" only when the data at the cell "C8" is equal to 1000 sec. and keep the previous one when is 500 sec. It is possible to do this?. Thanks in advance. Maperalia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data of two cells into one and change formula accordinaly
See one answer in your previous thread...
In article , maperalia wrote: I was given the following formula: =C$5 & "@" & C$6 & " A, B, C" However, I want it to be changed to the following formula: =C$5 & "@" & C$6 & " A, B, C, D" only when the data at the cell "C8" is equal to 1000 sec. and keep the previous one when is 500 sec. It is possible to do this?. Thanks in advance. Maperalia |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data of two cells into one and change formula accordinaly
JE;
Thanks for your quick response. I put the statament you gave me ( "=R5C & ""@"" & R6C & ""a, b, c"" & IF(R8C=""0.0025 in/min"","",d"","""")" ) and I got the following error message: "Compile Error: Expected:line number or label or statement or end of statement" Could you please tell me how to fix it? Thanks. Maperalia "JE McGimpsey" wrote: See one answer in your previous thread... In article , maperalia wrote: I was given the following formula: =C$5 & "@" & C$6 & " A, B, C" However, I want it to be changed to the following formula: =C$5 & "@" & C$6 & " A, B, C, D" only when the data at the cell "C8" is equal to 1000 sec. and keep the previous one when is 500 sec. It is possible to do this?. Thanks in advance. Maperalia |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data of two cells into one and change formula accordinaly
JE;
Do not worry. I found the problem anf fixed it. Basically, I forgot to add the rest of the statement. Thanks very much for your help. Maperalia "JE McGimpsey" wrote: See one answer in your previous thread... In article , maperalia wrote: I was given the following formula: =C$5 & "@" & C$6 & " A, B, C" However, I want it to be changed to the following formula: =C$5 & "@" & C$6 & " A, B, C, D" only when the data at the cell "C8" is equal to 1000 sec. and keep the previous one when is 500 sec. It is possible to do this?. Thanks in advance. Maperalia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| want to copy formula, only change one number in formula | Excel Worksheet Functions | |||
| Change results , change data in othe cells across the row | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Linear Mode
