Hello All,
I'm not very good with Excel at all and I need help in creating a logical formula with more than one value. I appreciate any help
Thank you !
It goes like this:
If anything in E2 through E101 is "1", and anything in F2 through F102 is 'JR", and anything in G2 through G102 is "Bricklayer" then I want the amount of $60.18 to appear in columns C2 through C101 as it applies.
Columns C2-C101 = Base Rate
Columns E2-E102 = Union Local
Columns F2-F102 = JR
Columns G2-G101 = Bricklayer
I'm not very good with Excel at all and I need help in creating a logical formula with more than one value. I appreciate any help
Thank you !It goes like this:
If anything in E2 through E101 is "1", and anything in F2 through F102 is 'JR", and anything in G2 through G102 is "Bricklayer" then I want the amount of $60.18 to appear in columns C2 through C101 as it applies.
Columns C2-C101 = Base Rate
Columns E2-E102 = Union Local
Columns F2-F102 = JR
Columns G2-G101 = Bricklayer
Success !!! That one did the trick !! Phew ! Too advanced for me, but I thank you for sticking with me !! I thought I had to throw in the towel and return the project.
