excel - Populate a column with 3 different values based on 4 conditions in spreadsheet -

excel - Populate a column with 3 different values based on 4 conditions in spreadsheet -

i have 2 sheets named "first" , "second" on spreadsheet.i populate status column 3 different value based on 4 conditions. next conditions;

first: if b:b=0 --> a second & third: if a:a<second!a2 , (index(a2:a,count(a2:a)))<today())) --> c fourth: if a:a<today() --> b

(if 3 fails, leave empty.)

following sample tables working on.

first

second

the next desired results on respective tables.

first

second

here have tried, says less 3 arguments allowed.

=if(b2>0, if(a2<today(), "b", ""), if(b2=0,"a", ""), if((and((a:a<second!a2),((index(a2:a,count(a2:a)))<today()))),"c",""))

please help me desired results based upon conditions.

just made few little changes , worked.

=if(b:b=0, "a", if(a:a<today(), if((and((a:a<second!a2),((index(a2:a,count(a2:a)))<today()))),"c","b"), ""))

excel google-spreadsheet spreadsheet openoffice-calc