If Hours >0, If Volume <= 0,(and vice-versa) then....

[Steve]

I have appx 50 rows of data, each with a name, 3 columns of different volume,
and hours:
Col A -name
Col B - Vol 1
Col C - Vol 2
Col D - Vol 3
Col E - Hours

I'd like formulas in the cells in the F & G columns to check if there is
volume in B1, C1, or D1, and if hours in E1. If there is vol but no hours for
row 1, I'd like F1 to produce -> A1 &"had vol but no hours".(see below)
And also, if no volume in either B2, C2, or D2, but hours in E2,
I'd like G2 to produce ->A2 &"has hours but no vol" (see below).
And if volume in either col's B, C or D, and Hours in E, then nothing in F3
& G3.
And down trhough all 50 rows.

A B C D E F G
Jim 0 0 12 0 Jim had vol but no hrs
Tim 0 0 0 8 Tim has hrs but no
vol.
Kim 3 0 0 8 "" ""

Thanks,

Steve

 

[T. Valko]

What result do you expect for this:

Name1...0...0...0...0

 

[Luke M]

F1 formula:

=IF(AND(SUM(B11)>0,E1=0),A1&" has vol but not hours","")

G1 formula:

=IF(AND(SUM(B11)=0,E1>0),A1&" has hours but no vol","")

 

[Steve]

Perfect..... and so simple.

I thought it was going to be more involved than that.

Thanks again,

Steve

 

[Steve]

Thanks for the thought, but the data I'm working with will only genereate if
there is either volume or hours.