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
|