I have a spreadsheet which I did not create, in which several formulas are returning @VALUE errors. The formulas are supposed to calculate warranty periods. I can't figure out why the formulas are not working. Any ideas?
Q4=IF(CELL("datatype",I4:I4)="l",I4,EDATE(I4,L4)) where I4 is a date and L4 is a number
R4=IF(CELL("datatype",J4:J4)="b","Not Known",EDATE(J4,M4)) where J4 is a date and M4 is a number
S4=IF(R4="Not Known",Q4,MIN(Q4:R4)) depends on R4 & Q4 being correct
T4=IF(CELL("datatype",S4:S4)="l","Undetermined",IF(S4>=TODAY(),"YES","NO")) depends on S4 being correct
Q4=IF(CELL("datatype",I4:I4)="l",I4,EDATE(I4,L4)) where I4 is a date and L4 is a number
R4=IF(CELL("datatype",J4:J4)="b","Not Known",EDATE(J4,M4)) where J4 is a date and M4 is a number
S4=IF(R4="Not Known",Q4,MIN(Q4:R4)) depends on R4 & Q4 being correct
T4=IF(CELL("datatype",S4:S4)="l","Undetermined",IF(S4>=TODAY(),"YES","NO")) depends on S4 being correct