A Leave-It-Be Choice????

  • Thread starter Thread starter GBL
  • Start date Start date
G

GBL

Hi:
This problem has to be elementary, but I must have too much brain-drain.
Will try to make it simple. A1:A20 already has values entered earlier
each month. At the end of the month I need a function to update these
values based on a condition. Is there a function that can possibly alter
SOME cells but not others?? For example; the IF function will NOT work due
to the negative argument. Example: IF(A1<10,$C$1,"") will substitute the
$C$1 value when the condition IS met, but I don't want to alter them if the
"A1<10" portion is NOT met!! (The negative portion of the IF statement will
blank-out the cells [due to the ""] that I do not want!!) How do I update
the values based on the condition without altering those that don't??
 
I must be missing something. Just replace the "" with 2 or 12 or "Joe" or
whatever. The formula has to do something.
 
GBL

Not sure why you have the "" if you want either C1 or no change.

=IF(A1<10,C1,A1) will return C1 or A1 depending upon condition.

Gord Dibben XL2002
 
Hi Gord:
Ask a complex question; get a simple answer (that I just couldn't see)!!
I know your suggestion will work!!

Thanks a bundle!!

GBL

Not sure why you have the "" if you want either C1 or no change.

=IF(A1<10,C1,A1) will return C1 or A1 depending upon condition.

Gord Dibben XL2002


Hi:
This problem has to be elementary, but I must have too much brain-drain.
Will try to make it simple. A1:A20 already has values entered earlier
each month. At the end of the month I need a function to update these
values based on a condition. Is there a function that can possibly alter
SOME cells but not others?? For example; the IF function will NOT work due
to the negative argument. Example: IF(A1<10,$C$1,"") will substitute the
$C$1 value when the condition IS met, but I don't want to alter them if the
"A1<10" portion is NOT met!! (The negative portion of the IF statement will
blank-out the cells [due to the ""] that I do not want!!) How do I update
the values based on the condition without altering those that don't??
Click to expand...
Click to expand...
 
Back
Top