update the IF condition with more conditions

Hi Team,

i am currently using the below formula and is trying to add a condition to this.

=IF(NETWORKDAYS(MAX(BI2,DATE(2014,6,1)),MIN(BJ2,DATE(2014,6,30)))<0,0,NETWORKDAYS(MAX(BI2,DATE(2014,6,1)),MIN(BJ2,DATE(2014,6,30))))

The condition i am trying to add is

if the result of the above formula is less than the value in cell BK2, then look if the number in B2 is availaible in sheet2 (another sheet) coloumn B.

If the number in B2 is available in sheet2 coloumn B,then the result should be BK2.
If the number in B2 is not available in sheet2 coloumn B,then the result should be above mentioned formula which is =IF(NETWORKDAYS(MAX(BI2,DATE(2014,6,1)),MIN(BJ2,DATE(2014,6,30)))<0,0,NETWORKDAYS(MAX(BI2,DATE(2014,6,1)),MIN(BJ2,DATE(2014,6,30))))

Please help

You mean like this?

=IF(Sheet2!A1>0,Sheet2!A1,IF(NETWORKDAYS(MAX(BI2,DATE(2014,6,1)),MIN(BJ2,DATE(2014,6,30)))<0,0,NETWORKDAYS(MAX(BI2,DATE(2014,6,1)),MIN(BJ2,DATE(2014,6,30)))))

You can do it some helper cells...
that would be easier to understand later on..
making it a single and big formula... is not advisable....



Regards....
Vikas Gautam


Say thanks, click *