#### 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: 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:

#### Aspychata

##### Serenity waves, beachy vibes
V.I.P Member

This a great resource, and they state it's free.

#### 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: 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.

Alright- a success story here at the forum. 