How should i write this formula?
If E6 = 1/2", AND G6=PVC-40 than = I6....(if not =0)
E6 an G6 has to meet the criteria otherwise its 0.
How should i write this formula?
If E6 = 1/2", AND G6=PVC-40 than = I6....(if not =0)
E6 an G6 has to meet the criteria otherwise its 0.
Last edited by adamheon; 03-18-2014 at 04:03 PM.
TMS: I forgot the bloody """Please Login or Register to view this content.
If understand you correctly....not sure PVC-40 is a type of PVC or PVC Minus 40....
Last edited by judgeh59; 03-18-2014 at 04:00 PM.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
If E6 = 1/2", AND G6=PVC-40 than = I6....(if not =0)
Note that, if the cell E6 actually has 1/2" with the double quote, you will need to double up in the formula.Please Login or Register to view this content.
@judgeh59: I had to test it to check the format
Regards, TMS
Last edited by TMS; 03-18-2014 at 04:02 PM.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you. Works perfect!
=IF(AND(LEFT(E6,3)="1/2",G6="PVC-40"),I6,0)
the " after the 1/2" made it difficult that is why there is a left(e6,3) in there.
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks