# Help: Complicated IF formula

#### santhoshlk

##### Board Regular
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

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### squirrel31

##### New Member
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.

Replies
20
Views
237
Replies
8
Views
43
Replies
6
Views
55
Replies
2
Views
56
Replies
3
Views
60