IF Function

**billykiller05** · 10-18-2007, 10:33 AM

I need some help with an IF Function. I am need to setup an IF Function to cover several columns. I need the function to be able to look at Column A, B, C, and D and see if any are blank. If any of these is blank I need the function to give "Pending". If all of these columns have a Y then I need the function to give me "Completed".

**oldchippy** · 10-18-2007, 10:36 AM

See similar question, just answered

http://www.excelforum.com/showthread...=1#post1839906

**VBA Noob** · 10-18-2007, 10:36 AM

Maybe

=IF(COUNTIF(A1:D1,"y")=4,"Complete","Pending")

VBA Noob

**billykiller05** · 10-18-2007, 10:50 AM

That worked great. Is there any way to set the function up where it will not show "Pending" if there is nothing entered into that row?

**VBA Noob** · 10-18-2007, 10:53 AM

Try

=IF(COUNTBLANK(A1:D1)=4,"",IF(COUNTIF(A1:D1,"y")=4,"Complete","Pending"))

VBA Noob

**billykiller05** · 10-18-2007, 11:05 AM

I tried IF(COUNTBLANK(A1:D1)=4,"",IF(COUNTIF(A1:D1,"y")=4 ,"Complete","Pending")) but I am still getting Pending on the blank row.

I have another function I only want returned on the rows which have data. My function is =IF(I3<H3,IF(I3=0, "Repealed", "Decrease"),"Increase").

**oldchippy** · 10-18-2007, 11:46 AM

With your first one, you have probably got a space in one of the cells, because it should work. Select A1:D1 and hit the Delete key.

For your second one, how about

=IF(AND(H3="",I3=""),"",IF(I3<H3,IF(I3=0,"Repealed","Decrease"),"Increase"))

**billykiller05** · 10-18-2007, 12:28 PM

For your second one, how about

=IF(AND(H3="",I3=""),"",IF(I3<H3,IF(I3=0,"Repealed ","Decrease"),"Increase"))

This work wonderfully, but I need to add another scenario (if possible). I need for it to be able to see all of the above plus if H3 is blank but I3 has a value then I need it to return "Enacted". Is there a way to maintain what I have and add this additional scenario?