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

S

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
 
L

Luke M

F1 formula:

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

G1 formula:

=IF(AND(SUM(B1:D1)=0,E1>0),A1&" has hours but no vol","")
 
S

Steve

Perfect..... and so simple.

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

Thanks again,

Steve
 
S

Steve

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top