Help: Complicated IF formula

santhoshlk

Board Regular
Joined
Feb 6, 2006
Messages
206
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
 

Some videos you may like

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
Joined
Sep 15, 2014
Messages
30
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,593
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top