If Statement in Excel 2010

I am attaching a spreadsheet that I need a formula for.  I' m not very good at this so I am asking for help.

I need an If statement built that says:
If Column N is >= to column F then "Y" Else "N".  

Column N is showing the highest rate of pay an employee can get.
Column F is the employee's Current rate of pay.

KR
H--Rate-of-Pay.xlsm
kvrogersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamCommented:
=if(F2>=N2,"Yes","No")  put O2 and then drag down
0
Ryan ChongCommented:
try formula:

=IF(N2>=F2,"Y","N")

and drag down for the following cells accordingly
0
kvrogersAuthor Commented:
Is there any way in VB to create this statement as the columns will continue to grow and I don't want the user to have to remember to click and drag calculation?

KR
0
Ryan ChongCommented:
>>Is there any way in VB to create this statement as the columns will continue to grow and I don't want the user to have to remember to click and drag calculation?

is that mean in future there's a possibility you may include new columns somewhere in the worksheet? or do you mean rows?

if you mean grow in number of rows, you can try this to copy the formula for once.

1. put in the formula (like: =IF(N2>=F2,"Y","N")) into the column you want, let's say Column O.
2. select the cell O2, press Ctrl+C
3. select the whole column O by clicking the column.
4. Right click and select Paste Special
5. Select paste "Formulas" or "Formulas and number formats"
6. Edit the cell O1 if it's a header.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kvrogersAuthor Commented:
Thank you that worked perfectly.  
KR
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.