IF Statements

[mlindquist]

I have a bunch of IF Statements that I need to run on a various column. Right now the user is manually filtering the columns based on certain values and then setting on column to a certain value. There are multiples of this where the value that is being set is the same column so the IF Statements will have to go in a certain order when flowing through the data.

Ex. If AK = blank and Y = NA and AA = Complete then AK = RA
If AK = Blank and W = PR and AA - Complete then AK = PR
and so on for about 20 or so conditions.

 

[Joe4]

It looks like you are wanting to check a cells value and update it based on other conditions (i.e. you are wanting to set the value of AK, but are also looking at the current value in AK).
Any cell in Excel can either contain a hard-coded value, or a formula, but never both at the same time.
So AK can either have a formula in it, or a hard-coded value in it.

If you want to consider what is currently in cell AK before changing its value, that will require VBA. Are you good with that?
If so, please post a small sample of your data for us see.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.