Help with sorting values and formulas to different columns

Good Afternoon,

EG: If column n has a value of 1 - I want it placed in column P
If column n has a value of 2- I want it placed in column Q

There is a formula in column N - (=sum(m2+l2) I am not sure if this will make a difference to the writing of the formula.

I have tried an if formula (if(N2=1, N2>2) but it is giving me an error.
I am missing something.
Thank you in advance for any help you may have.
V

in P2

=IF(N2=1,1,"")

In Q2

=IF(N2=2,2,"")

Sorry, I said there was a formula in N... that is not the case.

N would only be a value of 1 or 2 as in Peter and Paul

What I would like to do is have a formula that states that if Paul sold $100.00 total sales put it in column P but if Peter sold $100.00 put it in columm Q.
My formula runs like this:

Frame information - cost - retail - total profit (retail - cost) Lens information - cost - retail - total profit (retail - cost)- Salesperson (peter or paul) - Total profit (M2+L2)

I am having trouble making the Salesperson responsible for the total profit.

V

Please attach a file (not image) so that respondents (a) do not have to type in data and (b) have data with which test any formulas. Ensure the data is representative of your actual "real world" data.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the (remove confidential) data.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Thank you for your help... I am not seeing the attachment but I am hoping it worked.

Do you mean ....

In P2

=IF($N2=1,$M2,0) 1=Alison

in Q2

=IF($N2=2,$M2,0) 2=Tiffany

This works... Thank you very much for your help!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

This formula works, however in the column that does not coordinate with that value... it puts #Name?
The formula transfers to the correct column (P) but in the (Q) column it puts the #Name?.
I have to total the columns at the end of the month so would like opposite column to either be Nothing or 0
Is there a way to have that value 0 instead of #Name?

#NAME usually means something is a typo: check what is in Q as the formula for both is the same except for values of 1 & 2!