If - Then - Else ?

[The Football Ref]

I took an Access class years ago, but I have no idea how to program Excel.

I was hoping someone could tell me how to program an excel spreadsheet I am working on.


I have a column in which I enter either credit card or cash (i). And another column which has the amount paid (L). I would like to seperate the amounts into 2 additional columns depending on which kind of payment was used.

Something like, if -i- says "cash" then take -L- and put it in -N-, else -M-.

Is this possible in excel ?

[JBeaucaire]

Assuming the data starts at row2, titles in row1, then try this:

Please Login or Register  to view this content.

[teylyn]

Unless you are specifically after a VBA macro, you can also do this simply with formulas.

Something like, if -i- says "cash" then take -L- and put it in -N-, else -M-.

in N2 and copied down
=if(i2="cash", L2, "")

In M2 and copied down
=if(i2="cash", "", L2)

[The Football Ref]

Teylyn,


Thank You ! It worked perfectly.



JBeau,

I appreciate the effort, but that was waaaay ahead of my capabilities as of yet.

[JBeaucaire]

No problem. Posting in the Programming forum instead of General forums and then asking what sounds like a programming question mislead us to think you're seeking a programming solution.

The worksheet formula approach is always more preferable to VBA when it's available, in my opinion. Hat-tip to Tey.

========
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.