# 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
###### Who is Participating?

x
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.

Microsoft Excel ExpertCommented:
=if(F2>=N2,"Yes","No")  put O2 and then drag down
Business Systems Analyst , ex-Senior Application EngineerCommented:
try formula:

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

and drag down for the following cells accordingly
Author 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
Business Systems Analyst , ex-Senior Application EngineerCommented:
>>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.

Experts Exchange Solution brought to you by