| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISTEXT TRUE then copy formula from cell X
Im trying to do a conditional:
F1 is a formula that works. This is the end result Im looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT TRUE then copy formula from cell X
In F2 use the formula =IF(ISBLANK(G2),"",F1)
I'm assuming that if G2 is blank then you want F2 blank too? -- David Biddulph "E Cobb" wrote in message ... I'm trying to do a conditional: F1 is a formula that works. This is the end result I'm looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT TRUE then copy formula from cell X
I tried and it didn't work. It errors
I also tried =NOT(isblank(g2),"",F1) ? "David Biddulph" wrote: In F2 use the formula =IF(ISBLANK(G2),"",F1) I'm assuming that if G2 is blank then you want F2 blank too? -- David Biddulph "E Cobb" wrote in message ... I'm trying to do a conditional: F1 is a formula that works. This is the end result I'm looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT TRUE then copy formula from cell X
=IF(ISBLANK(G2),"",(F1)) works.
However, it gives me the value in F1 not the formula used in F1. Any more ideas? "David Biddulph" wrote: In F2 use the formula =IF(ISBLANK(G2),"",F1) I'm assuming that if G2 is blank then you want F2 blank too? -- David Biddulph "E Cobb" wrote in message ... I'm trying to do a conditional: F1 is a formula that works. This is the end result I'm looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT TRUE then copy formula from cell X
=IF(ISBLANK(G2),"",whatever_formula_you_now_want_t o_use_if_you_don't
want_F1) -- David Biddulph "E Cobb" wrote in message ... =IF(ISBLANK(G2),"",(F1)) works. However, it gives me the value in F1 not the formula used in F1. "David Biddulph" wrote: In F2 use the formula =IF(ISBLANK(G2),"",F1) I'm assuming that if G2 is blank then you want F2 blank too? -- David Biddulph "E Cobb" wrote in message ... I'm trying to do a conditional: F1 is a formula that works. This is the end result I'm looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT TRUE then copy formula from cell X
If you want help from the group, it isn't much good saying "it didn't work"
or "It errors". You'll need to tell us what error you're getting, as our clairvoyant powers are limited. If you're telling us that =IF(ISBLANK(G2),"",F1) didn't work, and yet you're telling us in another post that =IF(ISBLANK(G2),"",(F1)) did work, then I would be most suspicious. My guess is that instead of copying the formula from the post into your formula bar, you tried to retype it and made a typing error. I wouldn't expect =NOT(isblank(g2),"",F1) to work, as the syntax is invalid. -- David Biddulph "E Cobb" wrote in message ... I tried and it didn't work. It errors I also tried =NOT(isblank(g2),"",F1) ? "David Biddulph" wrote: In F2 use the formula =IF(ISBLANK(G2),"",F1) I'm assuming that if G2 is blank then you want F2 blank too? "E Cobb" wrote in message ... I'm trying to do a conditional: F1 is a formula that works. This is the end result I'm looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT TRUE then copy formula from cell X
Thanks David. This helps. I am assuming that I can not do 'exactly' what I
want which is to duplicate the copy/paste special so the formula smartly adds a row each time it is copied. It sounds like I will have to manually enter each cell formula with new whatever_formula values. Either way, I should be able to work with this. Thanks for all your help! "David Biddulph" wrote: =IF(ISBLANK(G2),"",whatever_formula_you_now_want_t o_use_if_you_don't want_F1) -- David Biddulph "E Cobb" wrote in message ... =IF(ISBLANK(G2),"",(F1)) works. However, it gives me the value in F1 not the formula used in F1. "David Biddulph" wrote: In F2 use the formula =IF(ISBLANK(G2),"",F1) I'm assuming that if G2 is blank then you want F2 blank too? -- David Biddulph "E Cobb" wrote in message ... I'm trying to do a conditional: F1 is a formula that works. This is the end result I'm looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISTEXT TRUE then copy formula from cell X
If you are trying to copy the formula from F1, but add one to the row
numbers, the easiest way is probably just to copy F1 into F2, and then add the extra bits around the formula =IF(ISBLANK(G2),"",...) -- David Biddulph "E Cobb" wrote in message ... Thanks David. This helps. I am assuming that I can not do 'exactly' what I want which is to duplicate the copy/paste special so the formula smartly adds a row each time it is copied. It sounds like I will have to manually enter each cell formula with new whatever_formula values. Either way, I should be able to work with this. Thanks for all your help! "David Biddulph" wrote: =IF(ISBLANK(G2),"",whatever_formula_you_now_want_t o_use_if_you_don't want_F1) "E Cobb" wrote in message ... =IF(ISBLANK(G2),"",(F1)) works. However, it gives me the value in F1 not the formula used in F1. "David Biddulph" wrote: In F2 use the formula =IF(ISBLANK(G2),"",F1) I'm assuming that if G2 is blank then you want F2 blank too? -- David Biddulph "E Cobb" wrote in message ... I'm trying to do a conditional: F1 is a formula that works. This is the end result I'm looking for. If cell (g2) has any text or is not blank Then I want that cell (F2) to equal the formula from cell (F1) (modified appropriately for this new cell) Then the same applies for F3, copy formula from F2. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function...cell ref is a formula so True is retd when False sh | Excel Worksheet Functions | |||
| How to: COUNTIF when ISTEXT is True? | Excel Worksheet Functions | |||
| ISTEXT | Excel Discussion (Misc queries) | |||
| I need help with a =sum IF ISTEXT formula. I keep getting 0. | Excel Discussion (Misc queries) | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Linear Mode
