I have if/then statements in 3 columns, and in the 4th column I want the sum of the displayed values in the first 3. How do I do that?

 

Nevermind, coworker helped me figure it out. Apparently if I do =SUM(G6:I6) it won't work, but if I do =SUM(G6+H6+I6) it does work. Weird.

 

Lol smooooooooooth. We used to use excel to schedule equipment for inspections

 

This is for a vehicle analysis, we have company vehicles and I'm applying a formula to show when the vehicle should be replaced. People always want a concrete answer of mileage or years, but obviously there's much more to it than that. Especially when all our cars are Impalas, and some are great but some fall apart. I enjoy learning new stuff, this (if/then statements) was a first for me:



=IF(A48<0.244,"0",IF(A48<0.324,"25",IF(A48<0.494," 50",IF(A48<0.654,"75",IF(A48<0.744,"100",IF(A48<0. 894,"150",IF(A48<0.999,"150",IF(A48>0.999,"DROPDEA D")))))