Here is what I need to do I have been working on a sales sheet that will
track the sales via a won loss ratio. Now what I have been trying to do is to
take all of the information from the "activity" sheet and copy or perfer move
it to a sheet based as "lost" or "Won". What I have worked out is the
following (r/c is short for row/colum)

=if(r/c="won", 'Won'! ,if(r/c="lost", 'Lost'! ,))

I think I have the start of this formula correct but as you can see i am
missing several key parts.