Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate a formula in excel
Hello. I am trying to figure out how to have a formula automatically be
applied to the next row but only once information has been entered into the cell which the formula applies. Like if I wanted to add a1 + b1 and have the result in c1. How would I set up the formula so that a result for c2 would only show and be applied if I entered information in a2 and b2? Hopefully this makes sense. Thanks for any help. Farris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate a formula in excel
One way:
C2: =IF(COUNT(A2:B2)=2,A2+B2,"") Copy down as far as required. In article , Farris wrote: Hello. I am trying to figure out how to have a formula automatically be applied to the next row but only once information has been entered into the cell which the formula applies. Like if I wanted to add a1 + b1 and have the result in c1. How would I set up the formula so that a result for c2 would only show and be applied if I entered information in a2 and b2? Hopefully this makes sense. Thanks for any help. Farris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate a formula in excel
hi, not sure if your mean columns or rows, if do mean "row" will try to use
the OFFSET() function, but with just what you showed in characters: =IF(OR(A1="",B1=""),"",A1+B1) which reads if either a1 or b1 = nothing, then nothing (TRUE), else perform operation (FALSE). "Farris" wrote: Hello. I am trying to figure out how to have a formula automatically be applied to the next row but only once information has been entered into the cell which the formula applies. Like if I wanted to add a1 + b1 and have the result in c1. How would I set up the formula so that a result for c2 would only show and be applied if I entered information in a2 and b2? Hopefully this makes sense. Thanks for any help. Farris |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate a formula in excel
I don't know if this will help:
=IF(OR(A2="",B2=""),"",A2+B2+IF(OFFSET(C2,-1,0)="",0,OFFSET(C2,-1,0))) cannot start in row 1 with this as it would be in error. "Farris" wrote: Hello. I am trying to figure out how to have a formula automatically be applied to the next row but only once information has been entered into the cell which the formula applies. Like if I wanted to add a1 + b1 and have the result in c1. How would I set up the formula so that a result for c2 would only show and be applied if I entered information in a2 and b2? Hopefully this makes sense. Thanks for any help. Farris |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate a formula in excel
This is my formula
=IF(AND(C4=39234,C4<=39447),1,0) now, how do I get it so that it will automatically be applied to c5 and enter the result but not show up in the formula bar until a value is placed in c5 "nastech" wrote: hi, not sure if your mean columns or rows, if do mean "row" will try to use the OFFSET() function, but with jusTt what you showed in characters: =IF(OR(A1="",B1=""),"",A1+B1) which reads if either a1 or b1 = nothing, then nothing (TRUE), else perform operation (FALSE). "Farris" wrote: Hello. I am trying to figure out how to have a formula automatically be applied to the next row but only once information has been entered into the cell which the formula applies. Like if I wanted to add a1 + b1 and have the result in c1. How would I set up the formula so that a result for c2 would only show and be applied if I entered information in a2 and b2? Hopefully this makes sense. Thanks for any help. Farris |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate a formula in excel
You can simplify your =IF(AND(C4=39234,C4<=39447),1,0) to
=--(AND(C4=39234,C4<=39447) If you want to check for a value in C4, then use =IF(C4="","",--AND(C4=39234,C4<=39447)) Copy down a row to apply to C5. Note that you said "not show up in the formula bar until a value is placed in c5". This wouldn't be possible. If a formula is there you can see it in the formula bar (unless protection stops you), but you can let the visibility of the *result* be dependent on conditions. -- David Biddulph "Farris" wrote in message ... This is my formula =IF(AND(C4=39234,C4<=39447),1,0) now, how do I get it so that it will automatically be applied to c5 and enter the result but not show up in the formula bar until a value is placed in c5 "nastech" wrote: hi, not sure if your mean columns or rows, if do mean "row" will try to use the OFFSET() function, but with jusTt what you showed in characters: =IF(OR(A1="",B1=""),"",A1+B1) which reads if either a1 or b1 = nothing, then nothing (TRUE), else perform operation (FALSE). "Farris" wrote: Hello. I am trying to figure out how to have a formula automatically be applied to the next row but only once information has been entered into the cell which the formula applies. Like if I wanted to add a1 + b1 and have the result in c1. How would I set up the formula so that a result for c2 would only show and be applied if I entered information in a2 and b2? Hopefully this makes sense. Thanks for any help. Farris |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automate a formula in excel
OK, I figured out what it was. You have to have "extend data range formats
and formulas" activated in the options, edit menu. Once you have entered at least five rows of the same formula it automatically applies the formula to the new rows "Farris" wrote: Hello. I am trying to figure out how to have a formula automatically be applied to the next row but only once information has been entered into the cell which the formula applies. Like if I wanted to add a1 + b1 and have the result in c1. How would I set up the formula so that a result for c2 would only show and be applied if I entered information in a2 and b2? Hopefully this makes sense. Thanks for any help. Farris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automate replace values in formula | Excel Discussion (Misc queries) | |||
automate formula | Excel Discussion (Misc queries) | |||
How can I automate something to be added to a formula in excel? | Excel Worksheet Functions | |||
Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions | |||
Automate simple calculation/formula | Excel Worksheet Functions |