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