Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter "if then" / logical into a already existing cells with form
I have put together financial statements in a work book. Now, i would like
to enter a logical / if then, segment to my equations but i dont want to go into each individual cell in the page, is there a way to do this for many or all cells at once? Or do i literally have to go into each cell and paste in the if then portion. All cells will be dependent on 1 of 3 drop down list choices. Would love some help onthis one. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter "if then" / logical into a already existing cells with form
Hi
With this little information of what you have in the cells, we can not give an exact answer. If the initial formula in all cells are basically the same (maybe looking at different rows), you can insert the if statement in the first cell and then copy the formula to other cells as required. Hopes this helps. .... Per "Indigo-JDJ" skrev i meddelelsen ... I have put together financial statements in a work book. Now, i would like to enter a logical / if then, segment to my equations but i dont want to go into each individual cell in the page, is there a way to do this for many or all cells at once? Or do i literally have to go into each cell and paste in the if then portion. All cells will be dependent on 1 of 3 drop down list choices. Would love some help onthis one. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter "if then" / logical into a already existing cells with form
We can usuallly use something like Find/Replace.
Post a before/after example to give us more information. -- Gary''s Student - gsnu200908 "Indigo-JDJ" wrote: I have put together financial statements in a work book. Now, i would like to enter a logical / if then, segment to my equations but i dont want to go into each individual cell in the page, is there a way to do this for many or all cells at once? Or do i literally have to go into each cell and paste in the if then portion. All cells will be dependent on 1 of 3 drop down list choices. Would love some help onthis one. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter "if then" / logical into a already existing cells with form
Sample code for adding to existing formulas.
Perhaps you can addapt or post back with some details. Sub ErrorTrapAdd() Dim myStr As String Dim cel As Range For Each cel In Selection If cel.HasFormula = True Then If Not cel.Formula Like "=IF(ISERROR*" Then myStr = Right(cel.Formula, Len(cel.Formula) - 1) cel.Value = "=IF(ISERROR(" & myStr & "),""""," & myStr & ")" End If End If Next End Sub Gord Dibben MS Excel MVP On Sun, 1 Nov 2009 23:10:01 -0800, Indigo-JDJ wrote: I have put together financial statements in a work book. Now, i would like to enter a logical / if then, segment to my equations but i dont want to go into each individual cell in the page, is there a way to do this for many or all cells at once? Or do i literally have to go into each cell and paste in the if then portion. All cells will be dependent on 1 of 3 drop down list choices. Would love some help onthis one. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add a "0" (zero) to the front of existing data in cells | Excel Discussion (Misc queries) | |||
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) |