I get a #VALUE! error in L1 using this formula if H1 is blank. Any
suggestions?
=(J1*0.01*(IF(K1="",TODAY(),K1)-IF(H1="",E1,H1))/365+G1)

E F G H I J K L
1/28/2009 210.00 1.17 8/20/2009 40.00 250.00 10/1/2009 1.46


Bonnie Mozingo