Copy contents of one cell to another based on the value of a third cell

[WGTE3091]

With using only cell formulas ...
(the company does not allow files with macros)

Is it possible to copy the value (text) in cell A1 to B1 ... if the value of cell F1 = 5.

In truth, if F1 = 5, then the value of cell A1 needs to be copied to cells B1, C1, D1, E1.


Thanks for any help.

RJW

 

[Eric W]

Welcome to the Board.

Put this formula in B1, and copy over to E1:

=IF($F1=5,$A1,"")

If there's already something there, or if you want B1:E1 to remain the same even if F1 or A1 changes in the future, then you'll need a macro, which I know your company doesn't allow.

 

[WGTE3091]

Thanks Eric W, that worked.

I tried an IF statement, but must not have had the right syntax.

RJW

 

[Eric W]

You're welcome.