Excel help

Reply Subscribe

Thread Tools

Search this Thread

12-22-2010, 09:46 AM

Baldy

Super Moderator

Thread Starter

Join Date: Sep 2002

Location: Tallahassee, FL

Posts: 5,425

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?

12-22-2010, 09:56 AM

Baldy

Super Moderator

Thread Starter

Join Date: Sep 2002

Location: Tallahassee, FL

Posts: 5,425

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.

12-22-2010, 09:22 PM

thatpoorguy

Senior Member

Join Date: Nov 2009

Location: peru, IN

Posts: 1,833

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

12-23-2010, 06:44 AM

Baldy

Super Moderator

Thread Starter

Join Date: Sep 2002

Location: Tallahassee, FL

Posts: 5,425

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")))))