somewhat complicated conditional formula

[Peter]

Hello, group - sorry, the subject line is probably not too helpful. Here'swhat I'm trying to do: A1 is a text entry box that will contain a comma-separated list of truncated dates (just years), e.g., "81, 82, 83" or "81". B1 is a currency-formatted box containing a dollar value.

C1 through, say, F1, are a series of currency-formatted cells whose contents I'd like to update programmatically, depending on the values in A1 and B1.. E.g. C1 might stand for the 1981 year, so if A1 contains "81, 82, 83" I'd like the contents of C1, D1, and E1 to be automatically updated, but F1 should just stay blank. Similarly, if A1 contains just "82", then only D1 should be updated and the rest of the cells should remain blank. For the sake of argument, let's assume the formula in C1-F1 is simple, something like"B1*5".

Is there a way to do this? Any help would be greatly appreciated.

 

[h2so4]

Peter presented the following explanation :

Hello, group - sorry, the subject line is probably not too helpful. Here's
what I'm trying to do: A1 is a text entry box that will contain a
comma-separated list of truncated dates (just years), e.g., "81, 82, 83" or
"81". B1 is a currency-formatted box containing a dollar value.

C1 through, say, F1, are a series of currency-formatted cells whose contents
I'd like to update programmatically, depending on the values in A1 and B1.
E.g. C1 might stand for the 1981 year, so if A1 contains "81, 82, 83" I'd
like the contents of C1, D1, and E1 to be automatically updated, but F1
should just stay blank. Similarly, if A1 contains just "82", then only D1
should be updated and the rest of the cells should remain blank. For the
sake of argument, let's assume the formula in C1-F1 is simple, something like
"B1*5".

Is there a way to do this? Any help would be greatly appreciated.

hello Peter

copy the following formula in C1-F1

=IFERROR(IF(FIND((COLUMN()+78),$A$1),$B$1*5,""),"")

 

[Peter]

Brilliant. Got it.