Question:
Excel formula help!! I need to subtract the sum of numbers from one cell?
Candy Apple Red
2010-10-12 09:07:52 UTC
My formula looks like this =IMSUB(=SUM(H5,H6),O7) But it's not working. I want to subtract the sum H5 and H6 from O7. What do I need to change?
Ten answers:
Todd
2010-10-12 09:11:20 UTC
You need to remove the "=" in the middle.



=IMSUB(SUM(H5,H6),O7) should do it.
?
2017-01-20 07:07:32 UTC
1
dustman
2016-12-26 20:04:32 UTC
Subtract Numbers In Excel
?
2016-10-03 11:21:44 UTC
Excel Minus Formula
?
2015-08-06 04:39:44 UTC
This Site Might Help You.



RE:

Excel formula help!! I need to subtract the sum of numbers from one cell?

My formula looks like this =IMSUB(=SUM(H5,H6),O7) But it's not working. I want to subtract the sum H5 and H6 from O7. What do I need to change?
lynn
2010-10-12 09:40:24 UTC
Use a minus sign (-) to subtract,

Subtract numbers in a cell

To do this task, use the - (minus sign) arithmetic operator.

For example, if you type the following formula in a cell:

10-5

The cell displays the following result:

5

(Use whatever cell you want to subtract for. example)

Description (Result)

=A2-A3 Subtracts 9,000 from 15,000 (6,000)

=SUM(A2:A4) Adds all numbers in the list, including negative numbers (16,000)



All these details are available in excel, go to help and type what you want to do. Subtract cell, add cell, divide cell, it will give you a step by step.



I hope this helps you.
?
2016-04-27 03:17:34 UTC
Reverse Phone Number Look Up Services
anonymous
2015-02-15 11:50:15 UTC
reverse phone number search compiles hundreds of millions of phone book records to help locate the owner's name, location, time zone, email and other public information.



Use a reverse phone lookup to:

Get the identity of an unknown caller.

Identify an area code.

Recall the name of a person whose number you wrote down.

Identify an unfamiliar phone number that shows up on your bill.

https://tr.im/FGqB7
anonymous
2015-05-11 23:23:48 UTC
excel formula subtract sum numbers cell: https://tinyurl.im/e/excel-formula-help-i-need-to-subtract-the-sum-of-numbers-from-one-cell
atiqa
2010-10-12 09:15:26 UTC
when you get the correct answer tell me the answer as well ok loll


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...