Hi, is there a way for cell results to be put into a different cell?
E.g. =IF(A2>A1,S1,S2) where A2>A1 is true S1 contents will be displayed with S2 contents displayed if not true, but I want to e.g.
=IF(A2>A1,5=S1,S2) I want to put i.e. 5 into cell S1.
Any ideas?
Thanks.
Bookmarks