Easy way to write complicated Ifs

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Is there an easy way to write a complicated IF statement such as :

=IF(ISBLANK(Unit_1),"",IF(ISBLANK(Unit_2),"",IF(ISBLANK(Unit_3),
IF(C27<D27,Unit_1,Unit_2),IF(E27<C27,IF(E27<D27,Unit_3,Unit_2),
IF(C27>D27,Unit_2,Unit_1)))))

....which took me hours to work out! This statement simply checks whether there is a value in some
column headers and than select the lowest value from three cells, C27, D27 and E27. If the first two
columns are empty it will print a "".

I have a good programming background but this stuff is hard to read...and write. Is there help out
there...I have 5 more statements that will be at least this complicated!

Thanks,

Todd
 
Hi Todd
try
IF(OR(Unit_1="",Unit_2=""),"",IF(Unit_3="",MIN(C25:E27),"not defined"))
 
Back
Top