Help: Complicated IF formula

[santhoshlk]

Dears I have the below =IF formula to calculate my DSO

=IF(E13=0,0,ROUND((IF(C13,MIN(E13,C13)/C13,1)*B13)+(((E13-C13)>0)*IF(C14,(MIN((E13-C13),C14)/C14),1)*B14)+(((E13-SUM(C13:C14))>0)*IF(C15,(MIN((E13-SUM(C13:C14)),C15)/C15),1)*B15)+(((E13-SUM(C13:C15))>0)*IF(C16,(MIN((E13-SUM(C13:C15)),C16)/C16),1)*B16),0))

in this formula data range is from row no 13 till row no 16 only.

i need to include the row no 17 to 20 in the same formula, how this possible

thanks - Santhosh

 

[squirrel31]

Hi,

From what I've heard and seen I believe you could potenitally use a Vlookup statement instead of this complicated IF statement. This way you'd also be able to include the additional requirements.

Don't take this as 100% guarantee as I am no excel expert but this is what I would explore if I were you.