• Welcome to Autism Forums, a friendly forum to discuss Aspergers Syndrome, Autism, High Functioning Autism and related conditions.

    Your voice is missing! You will need to register to get access to the following site features:
    • Reply to discussions and create your own threads.
    • Our modern chat room. No add-ons or extensions required, just login and start chatting!
    • Private Member only forums for more serious discussions that you may wish to not have guests or search engines access to.
    • Your very own blog. Write about anything you like on your own individual blog.

    We hope to see you as a part of our community soon! Please also check us out @ https://www.twitter.com/aspiescentral

Excel Spreadsheet Formula Help Please

Magna

Well-Known Member
V.I.P Member
I have to do something in Excel and I'm not able to make a simple formula work. Here is a screenshot of a section of my spreadsheet:

Screenshot-2022-11-30-121625.png


What I want to do is subtract the N3 cell value (131.67) from the O3 cell value (138.26) and I want the result to show in cell P3. I realize the answer given will be: -6.59 which is what I need. The reason I need to do a formula that works is that there are over 400 cells in the O and N columns that need the same outcomes and I don't want to have to manually calculate each P cell value for each row.

I do NOT want to add the two cell values together (e.g. 131.67+138.26=269.93)
Sometimes the number in the N column cell in a row will be higher than the number in the O column of that same row and sometimes it will be less. So the result in the P column for each row will sometimes be a positive number and sometimes a negative number.

I can't figure out how to do it.

Does anyone know how to do this?
 
Last edited:

Stuttermabolur

Wondering...
V.I.P Member
I have to do something in Excel and I'm not able to make a simple formula work. Here is a screenshot of a section of my spreadsheet:

Screenshot-2022-11-30-121625.png


What I want to do is subtract the N3 cell value (131.67) from the O3 cell value (138.26) and I want the result to show in cell P3. I realize the answer given will be: -6.59 which is what I need. The reason I need to do a formula that works is that there are over 400 cells in the O and N columns that need the same outcomes and I don't want to have to manually calculate each P cell value for each row.

I do NOT want to add the two cell values together (e.g. 131.67+138.26=269.93)
Sometimes the number in the N column cell in a row will be higher than the number in the O column of that same row and sometimes it will be less. So the result in the P column for each row will sometimes be a positive number and sometimes a negative number.

I can't figure out how to do it.

Does anyone know how to do this?
It doesn't work to put in a formula like "=O3-N3"? I know that if you go into the cell calculation settings, you can pick how negative numbers are displayed. I don't have a laptop with me now, so I don't think I can help you more. Like @Aspychata mentioned, it's often best to use an online search tool like Google when you have problems. That's what I tend to do when I have issues with Excel, and there are a lot of resources.
 

Magna

Well-Known Member
V.I.P Member
It doesn't work to put in a formula like "=O3-N3"? I know that if you go into the cell calculation settings, you can pick how negative numbers are displayed. I don't have a laptop with me now, so I don't think I can help you more. Like @Aspychata mentioned, it's often best to use an online search tool like Google when you have problems. That's what I tend to do when I have issues with Excel, and there are a lot of resources.
You saved the day! I was making it more complicated that I needed to. =sum(N3-O3) worked perfectly.

Thanks for your help. I did go to Google first but didn't find an answer that made sense to me.
 

New Threads

Top Bottom