Help with a logical formula

[MillieG]

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

 

[MillieG]

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.

Thank you mrhstn !!